topic Re: How to change number and datetime formats dynamically according to the country ? in QlikView

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

Mon, 05 May 2014 11:08:45 GMT

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.

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

jagan — Mon, 05 May 2014 11:15:37 GMT

Hi,

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

Regards,

Jagan.

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

Mon, 05 May 2014 11:20:50 GMT

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

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

jagannalla — Mon, 05 May 2014 11:49:43 GMT

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

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

jagan — Tue, 06 May 2014 02:24:10 GMT

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.

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

kaushiknsolanki — Tue, 06 May 2014 04:40:12 GMT

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

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

Sai_Krishna_BH — Fri, 17 Jan 2020 06:21:48 GMT

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