Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

week start on monday

Hi All,

I wrote following condition and its giving date starting from Friday. I need to modify this to get week start from Monday.

i tried weekstart(Load_Date) but its giving from Sunday

If(Weeks='DMD1',date(LOAD_DATE)

Any idea on how to get from monday ?

4 Replies
MVP
MVP

Re: week start on monday

May be this:

If(Weeks='DMD1', WeekStart(Date(LOAD_DATE)))

MVP
MVP

Re: week start on monday

Also make sure you have this in your environmental variables in script:

SET FirstWeekDay=0;

cacosta35
Contributor II

Re: week start on monday

Try

= weekstart(Load_Date) + 1

zhadrakas
Valued Contributor

Re: week start on monday

Hello uday,

the variable FirstWeekDay doesn't changed anything for me.

try this:

If(Weeks='DMD1',weekstart(date(LOAD_DATE),0,0))

the second Parameter of the weekstart function sets the startday of the week (0 = Monday)