WeekDays and Week Number

[jood_ahmad]

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.

[devarasu07]

Hi,

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

Redefining the Week Numbers

Week Start - Sunday instead of Monday

Thanks,Deva

[jood_ahmad]

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

[jood_ahmad]

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

[qlik4asif]

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/NumberInterpret...