topic Re: 2 week selection in Calendar in QlikView

2 week selection in Calendar

Anonymous — Thu, 18 Apr 2013 10:24:21 GMT

I've added following line into the Calender:

week(PeriodDate) -1) & '-' & week(PeriodDate) AS TwoWeeks,

When I look at the result in a table I see 1-2, 3-4, 5-6 etc. So far so good

But when using this result in a selection, it's only filtering the last week.
Selection week 34-35 only shows week 35
See image below

Gysbert_Wassenaar — Thu, 18 Apr 2013 19:25:50 GMT

Your field TwoWeeks is only linked with one Week, e.g week 35. To fix this you could try something like:

2*(floor((1+week(PeriodDate))/2))-1 &'-'& 2*(floor((1+week(PeriodDate))/2)) as TwoWeek

Anonymous — Fri, 19 Apr 2013 08:01:07 GMT

It works!
Thanks.