Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to displaying local date/time format and currency format based on user's country and regional settings

Can any one provide best practice document along with an example qvw for displaying local date/time format and currency format based on user's country and regional settings. Also, provide information on possibility of displaying data in the required format without coding it into every expression Constraints: -Only one document (qvw) for use by all countries -Formats of currency, dates, etc.. should be dynamically generated based on user configuration/country -Solution cannot be to have to modify every expression in a document to support this, determine if there is a more generic way to do this (setting document settings on load based on user, etc..)

2 Replies
sujeetsingh
Honored Contributor III

Re: How to displaying local date/time format and currency format based on user's country and regional settings

A tough thing to handle man.

Qlikview do not provide any feature to access the time zone from client.

It provides the function TimeZone() , but it only takes the time zone of the server.

If you need only the server time zone that you can use ,ConvertToLocalTime() function.

I am also giving you a thread from forum related to this.

User-specific date format

Hope it helps

jebamalai
Valued Contributor

Re: How to displaying local date/time format and currency format based on user's country and regional settings

Adding to Sujeet's comments,it will be very difiicult to convert the Currencies and all.Because each Currency plays major role in our application.so you have  to use the separate currency conversion logic.So one application with auto feature of Currency etc will be a highly difficult task as for as my knowledge.

Community Browser