How to change number and datetime formats dynamically according to the country ?

[#1]

I want to change local date/time format and currency format based on user's country and regional settings. Formats of currency, dates, etc.. should be dynamically generated based on user configuration/country. I don't want to modify each and every expression in the qlikview document.

Is there a generic way to do that ?

Any help is appreciated.

[jagan]

Hi,

Specify the date format in variable and refer that date variable in script and expressions.

Regards,

Jagan.

[#3]

Hi Jagan,

Thanks for your answer. But this won't help me because I don't want to modify my expressions.

Thanks & regards,

Aparna S. Borate

[jagannalla]

Hi,

How is your data model ?

If you have country and date field in single table. Load each country along with date field and concatenate all countries and link with main table.

For eg:

Load 'US' as Country

Date(DateField,'MM/DD/YYYY') as Date

Resident MainTable;

Load 'India' as Country

Date(DateField,'DD/MM/YYYY') as Date

Resident MainTable;

Hope it may helps you!!

Cheers!!

Jagan

[jagan]

Hi,

In this method you are not going to modify expressions, you are just specifying the format in one variable and using that in script and expressions if necessary.

LET vDateFormat = 'DD/MM/YYYY';

Data:

LOAD

*,

Date(DateDimensionName, $(vDateFormat )) AS Date

FROM DataSource;

if you want to change the date format just change the format in variables.

Regards,

Jagan.

[kaushiknsolanki]

Hi,

     Have a look at the "Financial Score Card" demo available on QlikView site. This is not exactly what you want, but I am sure this will give you guidance how to achieve the same with Date/time and Currency.

Regards,

Kaushik Solanki

[Sai_Krishna_BH]

I was not able to find the Financial Score Card demo can anyone help me with the link. I have a similar issue.