Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the use of below variables? In which business scenario we use those?
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
Thanks in advance for your help.
Hi,
This integer defines which day to use as the first day of the week.
Syntax:
FirstWeekDay
By default, QlikView functions use Monday as the first day of the week. The following values can be used:
Examples:
Set FirstWeekDay=6; //(set Sunday as the first day of the week)
The setting defines if weeks are broken or not.
Syntax:
BrokenWeeks
By default, QlikView functions use unbroken weeks. This means that:
The alternative is to use broken weeks.
The following values can be used:
Examples:
Set BrokenWeeks=0; //(use unbroken weeks)
Set BrokenWeeks=1; //(use broken weeks)
The setting defines which day in January to set as reference day to define week 1.
Syntax:
ReferenceDay
By default, QlikView functions use 4 as the reference day. This means that week 1 must contain January 4, or put differently, that week 1 must always have at least 4 days in January.
The following values can be used to set a different reference day:
Examples:
Set ReferenceDay=3; //(set January 3 as the reference day)
- Anil
Hi,
If you want Monday, then you should use
Set FirstWeekDay = 0; // 0=Mon, 1=Tue, ... , 6=Sun
And if you want Sunday, you should use
Set FirstWeekDay = 6; // 0=Mon, 1=Tue, ... , 6=Sun
Hi,
This integer defines which day to use as the first day of the week.
Syntax:
FirstWeekDay
By default, QlikView functions use Monday as the first day of the week. The following values can be used:
Examples:
Set FirstWeekDay=6; //(set Sunday as the first day of the week)
The setting defines if weeks are broken or not.
Syntax:
BrokenWeeks
By default, QlikView functions use unbroken weeks. This means that:
The alternative is to use broken weeks.
The following values can be used:
Examples:
Set BrokenWeeks=0; //(use unbroken weeks)
Set BrokenWeeks=1; //(use broken weeks)
The setting defines which day in January to set as reference day to define week 1.
Syntax:
ReferenceDay
By default, QlikView functions use 4 as the reference day. This means that week 1 must contain January 4, or put differently, that week 1 must always have at least 4 days in January.
The following values can be used to set a different reference day:
Examples:
Set ReferenceDay=3; //(set January 3 as the reference day)
- Anil