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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there an easy way to change time, currency, date, etc, formatting within Qlik Sense?

Hello,

I am new to Qlik Sense.  I have a few apps created that I have been working with. I am trying to get more comfortable with the data load editor and the one thing that is bugging me is changing the time format from military to a 12 hour clock. Plus any other formatting information that you could provide would be helpful.

Thanks for your help.

2 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

To change the format of the date use Date() or TimeStamp() functions, refer Qliksense help file for more details.

Regards,

Jagan.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The SET statements at the beginning of your script set the default formats. For example, to change your time to 24 clock:

SET TimeFormat='h:mm:ss';

In a new script, the default SET statements are built from the window locale settings.

Rob