ReferenceDay
Syntax:
ReferenceDay
The setting defines which day in January to set as reference day to define week 1. 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:
- 1 (= January 1)
- 2 (= January 2)
- 3 (= January 3)
- 4 (= January 4)
- 5 (= January 5)
- 6 (= January 6)
- 7 (= January 7)
Examples:
Set ReferenceDay=3; //(set January 3 as the reference day)