FirstWeekDay

Overview

Open the Data load editor and add the load script below to a new tab.

In this example, the load script uses the default Qlik Sense system variable value, FirstWeekDay=6. This data contains data for the first 14 days in 2020.

Load script

// Example 1: Load Script using the default value of FirstWeekDay=6, i.e. Sunday

SET FirstWeekDay = 6;

Sales:
LOAD
	 date,
	 sales,
	 week(date) as week,
	 weekday(date) as weekday 
Inline [
date,sales
01/01/2021,6000
01/02/2021,3000
01/03/2021,6000
01/04/2021,8000
01/05/2021,5000
01/06/2020,7000
01/07/2020,3000
01/08/2020,5000
01/09/2020,9000
01/10/2020,5000
01/11/2020,7000
01/12/2020,7000
01/13/2020,7000
01/14/2020,7000
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• date

• week

• weekday

Because the default settings are being used, the FirstWeekDay system variable is set to 6. In the results table, each new week can be seen beginning on Sunday (the 5th and 12th of January).

Overview

Open the Data load editor and add the load script below to a new tab.

In this example, the data contains the first 14 days in 2020. At the start of the script, we set the FirstWeekDay variable to 3.

Load script

// Example 2: Load Script setting the value of FirstWeekDay=3, i.e. Thursday

SET FirstWeekDay = 3;

Sales:
LOAD
	date,
	sales,
	week(date) as week,
	weekday(date) as weekday 
Inline [
date,sales
01/01/2021,6000
01/02/2021,3000
01/03/2021,6000
01/04/2021,8000
01/05/2021,5000
01/06/2020,7000
01/07/2020,3000
01/08/2020,5000
01/09/2020,9000
01/10/2020,5000
01/11/2020,7000
01/12/2020,7000
01/13/2020,7000
01/14/2020,7000
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• date

• week

• weekday

Because the FirstWeekDay system variable is set to 3, the first day of each week will be a Thursday. In the results table, each new week can be seen beginning on Thursday (the 2nd and 9th of January).