Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

ogster1974
Honored Contributor II

Localisation of Reports

Hi Experts

I have reports that im producing for a global audience what is the best practise for making sure:

Dates are formatted correctly

E.g.

US users like to see dates in MM/DD/YYYY format

ROW users like to see dates in DD/MM/YYYY format

Numbers are formatted correctly

E.g

UK users like to see numbers 1,000.00

German users like to see numbers 1.000,00

Any thoughts and recomendations on the best way to bring this kind of presentation into the reports.

Regards

Andy

1 Solution

Accepted Solutions

Re: Localisation of Reports

7 Replies

Re: Localisation of Reports

Does your data fetching country level or world wide. If country level it may possible by using Ad hoc reports. But, If World data then could be a different approach. I am not sure whether that will work for Dashboard oriented

ogster1974
Honored Contributor II

Re: Localisation of Reports

It shouldnt matter the report content or level its a user experience question.

Say I have a simple table in a report with 3 columns Name, Date and Value

A user in the US might want to see the table like (Date formatted MM/DD/YYYY, Value #,##0.00)

NAMEDATEVALUE
A04/20/20171,000.00
B04/15/20172,000.00
C04/17/20173,000.00
D04/01/20171,750.00
E04/07/20171,000.00

A user in the UK might want to see it like (Date formatted DD/MM/YYYY, Value #,##0.00)

NAMEDATEVALUE
A20/04/20171,000.00
B15/04/20172,000.00
C17/04/20173,000.00
D01/04/20171,750.00
E07/04/20171,000.00

A user in Germany might want to see it like (Date formatted DD/MM/YYYY, Value #.##0,00)

NAMEDATEVALUE
A20/04/20171.000,00
B15/04/20172.000,00
C17/04/20173.000,00
D01/04/20171.750,00
E07/04/20171.000,00
ogster1974
Honored Contributor II

Re: Localisation of Reports

Any thoughts on this?

Re: Localisation of Reports

I got the requirement. I am saying i would suggest to go Ad Hoc reports with Country based for conditional enable. JAM He marcus_sommer‌ may help for us

Re: Localisation of Reports

Re: Localisation of Reports

how do you recognize that user is from UK or Germany etc?

ogster1974
Honored Contributor II

Re: Localisation of Reports

Interesting question.

I have with my users a language attribute in the data so en-gb for UK users, en-us for US users de for German etc...

I'm looking for the most appropriate way to bring this into my reports.

Do I go the section access route?

Do I create a language group?

Or can I leverage the locale field in the user import file?

Or do I use a user filter on a report to pass the variable or create sesperate reports per language and group the users or apply a report filter?

Looking for the pros and cons of each approach?

Community Browser