Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense Autocalendar Date Format

I can see in the load script that there is some autocalendar scripting. I haven't touched this however I have changed the following two variables

SET DateFormat='DD/MM/YYYY';

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

Despite doing this, the autocalendar sill results in showing M/D/YYYY format.

Below we can see that autocalendar is working.

autocal.png

Below we can see that the dates have not changed. I have also attempted to re-load the data. Thanks

dates.png

2 Replies
pathiqvd
Creator III
Creator III

Hi,

   write date format in auto calendar script like,

Date(Floor($1),'DD/MM/YYYY') AS [Date] Tagged ('$axis', '$date', '$qualified'),

Regards,

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

And you reloaded after changing the variable?

-Rob