Date Format on country based

[manoranjan_d]

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.

[F_B]

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

[manoranjan_d]

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?  

[F_B]

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