Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

narband2778
New Contributor III

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
New Contributor III

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.

bkilicli
New Contributor

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
New Contributor III

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"

Community Browser