Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

And you reloaded after changing the variable?

-Rob