topic Re: WeekDays and Week Number in QlikView

WeekDays and Week Number

jood_ahmad — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

Good day,

Actually, I got confused. I try to fix my calendar to start on Sunday instead of Monday but it doesn't work and when I get the week number also I get one-day forward especially at the end of the year if the week between Dec 2017 and Jan 2018 and so on.

Any Idea, please.

Re: WeekDays and Week Number

devarasu07 — Tue, 30 Jan 2018 06:48:27 GMT

Hi,

Refer to the @HIC article on redefine week number. thanks

Redefining the Week Numbers

Week Start - Sunday instead of Monday

Thanks,Deva

Re: WeekDays and Week Number

jood_ahmad — Tue, 30 Jan 2018 08:43:26 GMT

No still getting wrong daysname in wrong day number and by defult the week will be wrong.

Re: WeekDays and Week Number

jood_ahmad — Tue, 30 Jan 2018 09:04:21 GMT

I'm trying something it may work.........

Re: WeekDays and Week Number

qlik4asif — Tue, 30 Jan 2018 09:13:12 GMT

Change Env variables to

SET FirstWeekDay=6;

By default, QlikView functions use Monday as the first day of the week. The following values can be used:

0 (= Monday)
1 (= Tuesday)
2 (= Wednesday)
3 (= Thursday)
4 (= Friday)
5 (= Saturday)
6 (= Sunday)

Examples:

Set FirstWeekDay=6; //(set Sunday as the first day of the week)

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/NumberInterpretationVariables/DecimalSep.htm