Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
balajibc64
Specialist
Specialist

Date format in Data Load Editor

In Qlik Sense, Under Monitoring Apps --> Operation Monitors. I 'm creating new app under my workspace. When I tried to create the initial data load editor page is showing some default format for date and firstday etc. How to change from master level. For Eg. Its showing US format (M/DD/YYYY) but for me it show (DD/MM/YYYY) format. Currently doing manually, how to make a default settings. ?

@Albert_Candelario Could you guide me 

Labels (1)
1 Solution

Accepted Solutions
Albert_Candelario

Hello @balajibc64 ,
I would recommend to change the regional setting for the service account user of Qlik Sense on the Qlik Sense servers as per you wishing format.

https://community.qlik.com/t5/Official-Support-Articles/How-to-change-Windows-regional-settings-and-...

Let us know how it goes when performing the upgrade!

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer

View solution in original post

10 Replies
AgatheClero
Partner - Contributor II
Partner - Contributor II

Hi @balajibc64 ,

In the Main section at the beginning of your script, you can define a variable named DateFormat like this :

SET DateFormat='DD/MM/YYYY';

balajibc64
Specialist
Specialist
Author

You are saying like in Data load editor script ? Yes I can able to set. But I'm asking default while loading the editor script page itself format should be like this. 

AgatheClero
Partner - Contributor II
Partner - Contributor II

The default values ​​depend on the settings of your server where Qlik is installed.
Either you have to modify these parameters directly on the server, or you have to modify them manually in each script...

balajibc64
Specialist
Specialist
Author

Either you have to modify these parameters directly on the server. It means ? Also how to setup while installing 

balajibc64
Specialist
Specialist
Author

@AgatheClero Could you please any screenshot if possible. Parameter SET DateFormat='DD/MM/YYYY' this i can able to do this. But lookinf default code itself should be in this format

Albert_Candelario

Also have a look at https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/UserInterface/Languages.... for Qlik Cloud and 

https://community.qlik.com/t5/Official-Support-Articles/How-to-change-Windows-regional-settings-and-...

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
balajibc64
Specialist
Specialist
Author

@Albert_Candelario Just look into this url. After installation Qlik Sense in that particular server also shall we change this setup or else after change the setup need to redo fresh installation ?

Albert_Candelario

@balajibc64 did you already sort out or you still need help here?

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
balajibc64
Specialist
Specialist
Author

@Albert_Candelario Need to sort. Put on hold the reason planning to upgrade the latest version. Could you please suggest if anything need to do while installing the software.