Line Chart Date Format Changing when Zooming in.

[#1]

Hello,

I have a simple line chart with my dimension as 'Date', which is being loaded  as mm/dd/yyyy. I even have set the format as Date and 'MM/DD/YYYY' in the number tab in properties. Before zooming, or applying a slider filter, the date is showing in the correct format. However, when I zoom in to look at one specific month, the format changes to 'DD/MM/YYYY'. Does anyone know how to prevent this?

Example Attached

@Sunny T

[sunny_talwar · Accepted solution]

I think you need to change your environmental variables here:

Change it to this:

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';

and reload to check if that fixes the issue

[#3]

This worked! Thank you very much!

[sunny_talwar]

Great, please close this thread by marking the correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[#5]

Sunny,

I do not see the option to select 'Correct Answer' as is depicted in your Tip.