Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

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
Specialist
Specialist

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.