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

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

Mon, 05 May 2014 09:29:05 GMT

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..)

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

sujeetsingh — Tue, 05 Aug 2014 10:46:19 GMT

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

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

Anonymous — Tue, 05 Aug 2014 10:51:46 GMT

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.