topic Week Range to Start from Thursday and end on Wednesday in QlikView

Week Range to Start from Thursday and end on Wednesday

lakshmanvepuri — Fri, 19 Feb 2016 04:20:44 GMT

Hi ,

I would to change the WeekStart and Weekend as Customized as per the Standards.

I am able to get the week start and week end range as below

dual(Date(WeekStart([INFORM_DATE]),'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE]),'MMM DD') ,Week([INFORM_DATE])) as week_range.

Result for February

Feb 01 - Feb 07

Feb 08 - Feb 14

Feb 15 - Feb 21

I want the week range should start from Thursday and end on Wednesday.

Jan 28 - Feb 03

Feb 04 - Feb 10

Feb 11 - Feb 17

Feb 18 - Feb 24

Please advise me how to achieve that..?

Thanks a lot.

regards

Lakshmana

sunny_talwar — Fri, 19 Feb 2016 10:13:53 GMT

Try this:

=Dual(Date(WeekStart([INFORM_DATE], 0, 3), 'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE], 0, 3), 'MMM DD') , Week([INFORM_DATE]))

Tue, 08 Mar 2016 10:53:59 GMT

Hi Sunny,

I have same requirement like above, but in my scenario I want to show number of records as well in that particular week (last week or previous week)

In my scenario my week starting from Friday and Ending on Thursday and I am trying to calculate in expression, but didn't succeed, need help here.