topic Re: Weekstart change to Sunday in QlikView

Weekstart change to Sunday

Mon, 09 Sep 2013 07:06:10 GMT

Hi,

I would like to change the weekstart to Sunday. I tried to change weekstart([Re Date],0,-1) but it doesnt work. Below is my sceipt.

Please help!

if( month(weekstart([Re Date]))= month([Re Date]),weekstart([Re Date]),
if(weekday(makedate(Year ([Re Date]),month([Re Date]),1))=5,makedate(Year ([Re Date]),month([Re Date]),3),
if(weekday(makedate(Year ([Re Date]),month([Re Date]),1))=6,makedate(Year ([Re Date]),month([Re Date]),2),makedate(Year ([Re Date]),month([Re Date]),1))))
& ' to ' &
if( month(weekend([Re Date]))= month([Re Date]),makedate(year([Re Date]),month([Re Date]),day (weekend([Re Date]))-2),
if(weekday(monthend([Re Date]))=5,makedate(Year ([Re Date]),month([Re Date]),day(monthend([Re Date]))-1),
if(weekday(monthend([Re Date]))=6,makedate(Year ([Re Date]),month([Re Date]),day(monthend([Re Date]))-2),monthend([Re Date])))) as [App weekperiod],
if(week(makedate(year([Re Date]), month([Re Date]),1))>week([Re Date]),
week(makedate(year([Re Date]), month([Re Date]),1))+
week([Re Date])- week(makedate(year([Re Date]), month([Re Date]),1))+1,
week([Re Date])- week(makedate(year([Re Date]), month([Re Date]),1))+1) as [App week]

Re: Weekstart change to Sunday

tresB — Mon, 09 Sep 2013 07:09:57 GMT

Try:

weekstart([Re Date],0,6)

Re: Weekstart change to Sunday

orital81 — Mon, 09 Sep 2013 07:12:31 GMT

Try This:

Date(weekstart([Re Date])-1)

Re: Weekstart change to Sunday

Mon, 09 Sep 2013 07:27:36 GMT

still not working...
if( month(weekstart([Re Date],0,6))= month([Re Date]),weekstart([Re Date],0,6)

If there is any other areas that I need to amend.

Re: Weekstart change to Sunday

Mon, 09 Sep 2013 07:28:34 GMT

still not working...
if( month(weekstart([Re Date]-1))= month([Re Date]),weekstart([Re Date]-1)

If there is any other areas that I need to amend.

Re: Weekstart change to Sunday

Gysbert_Wassenaar — Mon, 09 Sep 2013 07:29:13 GMT

See this blog post: Ancient Gods and Modern Days

Re: Weekstart change to Sunday

Mon, 09 Sep 2013 07:41:34 GMT

Try :

=WEEKDAY(Floor(WEEKDAY([Re Date])+8))