topic Re: Line Chart Date Format Changing when Zooming in. in QlikView

Line Chart Date Format Changing when Zooming in.

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Line Chart Date Format Changing when Zooming in.

sunny_talwar — Wed, 18 May 2016 21:11:47 GMT

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

Re: Line Chart Date Format Changing when Zooming in.

Thu, 19 May 2016 12:16:24 GMT

This worked! Thank you very much!

Re: Line Chart Date Format Changing when Zooming in.

sunny_talwar — Thu, 19 May 2016 13:14:30 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Line Chart Date Format Changing when Zooming in.

Thu, 19 May 2016 13:21:50 GMT

Sunny,

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