topic Re: week function problem in QlikView

week function problem

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

I am using the week function to get the number of week of the year,

but I need that the starting point of a week be Monday not Sundat in order to count weeks

Can I change this?

Thanks in advance

Chanty4u — Tue, 12 Apr 2016 12:19:52 GMT

agustinbobba — Tue, 12 Apr 2016 12:20:18 GMT

Hi Juan,

Try Use WeekStart function

Best regards

Agustin

sunny_talwar — Tue, 12 Apr 2016 12:20:21 GMT

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

MK_QSL — Tue, 12 Apr 2016 12:20:34 GMT

Chanty4u — Tue, 12 Apr 2016 12:20:48 GMT

chk dis

swuehl — Tue, 12 Apr 2016 12:21:34 GMT

Which QV version are you using?

Have a look also at

alexis — Mon, 25 Jul 2022 11:25:15 GMT

Should the solution for setting the first day of the week to Monday not be

SET FirstWeekDay = 0;

instead of the suggested

FirstWeekDay=6;