Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
narband2778
Contributor II

How to Change default script settings in QlikSense

Hello Everyone,

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

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

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET CreateSearchIndexOnReload=1;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

How to change above mentioned DateFormat and TimestampFormat from 'M/D/YYYY' to 'DD/MM/YYYY'

Thanks in Advance,

Tags (1)
5 Replies
arulsettu
Honored Contributor III

Re: How to Change default script settings in QlikSense

did you tired like this

SET DateFormat='DD/MM/YYYY';

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

narband2778
Contributor II

Re: How to Change default script settings in QlikSense

Sorry, let me rephrase my question. whenever I open the app in HUB the default setting of DateFormat and TimestampFormat should be 'DD/MM/YYYY'.

Thanks,

balabhaskarqlik
Honored Contributor

Re: How to Change default script settings in QlikSense

Think so, this can be done by Administrator.

Highlighted
Partner
Partner

Re: How to Change default script settings in QlikSense

You should change format settings in Control Panel > Region. Qlik Sense is generating main script in according to machine's regional format settings.

regionalsetting.PNG

narband2778
Contributor II

Re: How to Change default script settings in QlikSense

Did these changes, but still not looking good. Still showing the same format "M/D/YYYY"