topic Re: Date Format on country based in App Development

Date Format on country based

manoranjan_d — Fri, 15 Nov 2024 20:59:14 GMT

Date column format for US (mm/dd/yyyy) is different from Europe (yyyy-mm-dd). Is there a solution in Qlik where in when the user is in Europe and exported data, the date will automatically converted to the country format. So that users will not have to convert manually.

Re: Date Format on country based

F_B — Tue, 30 Apr 2024 12:40:33 GMT

Hi @manoranjan_d,

as far as I know there isn't a direct option, but I can think about a workaround that might be useful.

I suppose you have a Table Chart you want to export, and a field with a date (let's call it Date_Field), in this case I would:

1. create two buttons (let's say US and EUROPE)

2. create a variable (let's call it vDateFormat)

3. add action to the buttons - Set variable value (let's say 1 for US and 0 for EUROPE)

4. edit expression in the Table Chart, something like =if (vDateFormat=1,Date(Date_Field, 'MM/DD/YYYY'),Date(Date_Field,'YYYY-MM-DD'))

This way the user can choose the date format to the visualization and to the export.

Hope this can be helpful, bye

Re: Date Format on country based

manoranjan_d — Fri, 03 May 2024 06:42:52 GMT

Hi F_B, Thanks for the suggestion, now my situation is ,dashboard is having 33 unique countries existing, how to overcome on this situation if they requesting each country with different format.

Any chance of pulling all the countries , user id, first name from the active directory of the AD group for the dashboard and finally making left join with 33 unique country date format and declaring the variable and calling in the dim or measure of the chart.

any idea or suggestion for the Initial step of getting the data from active directory?

Re: Date Format on country based

F_B — Fri, 03 May 2024 07:10:31 GMT

Nice idea. I also am interested about suggestions to get the necessary informations.