SET ThousandSep = ’ , ’ ;
- If you have a number like 1000000, it will display as 1,000,000
SET DecimalSep = ’ . ’ ;
- A number like 1234.56 will show as 1234.56. If you wanted to use a comma instead, you could set SET DecimalSep = ’ , ’ ; and then 1234.56 would show as 1234,56.
SET MoneyThousandSep = ’ , ’ ;
- A currency amount like 1000000 will display as 1,000,000 separating thousands with commas.
SET MoneyDecimalSep = ’ . ’ ;
- A currency value like 1234.56 will appear as 1234.56.
SET MoneyFormat = ’$ ###0.00;-$ ###0.00';
- A positive value like 1234.56 will display as $ 1,234.56.
- A negative value like -1234.56 will display as -$ 1,234.56.
SET TimeFormat = ’h:mm:ss TT’ ;
- A time like 16:25:30 would display as 4:25:30 PM.
- A time like 09:05:15 would display as 9:05:15 AM.
SET DateFormat = ’M/D/YYYY’ ;
- A date like October 20, 2024 would display as 10/20/2024.
SET TimestampFormat = ’M/D/YYYY h:mm:ss[.fff] TT’;
- Month/Day/Year Hour:Minute:Second AM/PM
- A timestamp like January 5, 2024, 14:05:30.123 would display as 1/5/2024 2:05:30.123 PM.
SET FirstWeekDay = 6;
- Qlik will start the week on Saturday (where Sunday = 0, Monday = 1, and so on.
SET BrokenWeeks = 1 ;
- If a week doesn’t have all seven days, it will still be counted in reports, so no data is missed.
SET ReferenceDay = 0;
- Sunday is treated as the starting point for any date-related calculations in your Qlik application.
SET FirstMonthOfYear = 1;
- January is treated as the first month of the year in your Qlik application.
SET CollationLocale = ’en-US’;
- Qlik will sort and compare text based on the rules of American English.
SET CreateSearchIndexOnReload = 1;
- Every time your data is updated in Qlik, a search index is created to help users quickly find information in the dataset.
SET MonthNames = ’Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec’;
- The months as abbreviated names in application.
SET LongMonthNames = ’January;February;March;April;May;June;July;August;September;October;November;December’;
- Qlik will display the months with their full names.
SET DayNames = ’Mon;Tue;Wed;Thu;Fri;Sat;Sun’;
- The days of the week using their short forms.
SET LongDayNames = ’Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday’;
- The days of the week with their full names.
SET NumericalAbbreviation = ’3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y’;
- 3:k : Thousands (k)
- 6:M : Millions (M)
- 9:G : Billions
- 12:T : Trillions
- 15:P : Quadrillions
- 18:E : Quintillions
- 21:Z : Sextillions
- 24:Y : Septillions
- -3:m : Millis
- -6:μ : Micros
- -9:n : Nanos
- -12:p : Picos
- -15:f : Femto
- -18:a : Atto
- -21:z : Zepto
- -24:y : Yocto
