topic Re: Weekstart should be based on weekday in QlikView

Weekstart should be based on weekday

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

Hi all,

My issue is, I need to create a calendar in which weekstart date should change according to my weekday. Ex. If I select weekday as Tuesday then my weekstart date should automatically change to Tuesday.

Regards,

Yasmeen

Re: Weekstart should be based on weekday

Gysbert_Wassenaar — Tue, 10 May 2016 09:13:36 GMT

The Weekstart function accepts an parameter for the day that should be used as the start of the week: weekstart ( '2016-01-12', 0, 2 ). If that should depend on a selection then use a variable with an expressions that calculates the weekday number of the selected day and use that weekstart ( '2016-01-12', 0, $(vWeekDayNumber) )

Re: Weekstart should be based on weekday

swuehl — Tue, 10 May 2016 09:35:36 GMT

Just a minor correction, I think WeekDay start counting from 0

(equals Monday, using default weekday counting, i.e. if not changed in script in a recent QV version).

Hence Tuesday would probably be represented by 1, this should be used as weekstart offset when you want to start the week on midnight between monday and tuesday.

weekstart ( '2016-01-12', 0, 1 )

Re: Weekstart should be based on weekday

Gysbert_Wassenaar — Tue, 10 May 2016 09:49:39 GMT

You're absolutely right. I often get this mixed up.

Re: Weekstart should be based on weekday

swuehl — Tue, 10 May 2016 09:52:49 GMT

Me too. Index start is not consistent in Qlik between functions