topic Re: Calender week selection in QlikView

Calender week selection

Wed, 21 May 2014 12:19:26 GMT

Hi All,

I have developed calendar but in that if i ll select February then in that only 4 weeks are there but week 5 is also enabled so
I want week selection as per of month It means if a month having only 4 weeks then only 4 weeks will enabled.QlikTech Admin

Re: Calender week selection

senpradip007 — Wed, 21 May 2014 12:33:19 GMT

You can try like:

Load

If( Day([Your Date]) >=1 and Day([Your Date]) <=7, 'Week 1',

If( Day([Your Date]) >=8 and Day([Your Date]) <=14, 'Week 2',

If( Day([Your Date]) >=15 and Day([Your Date]) <=21, 'Week 3', 'Week 4'))) As MonthWeek

From <Your Table>;

Re: Calender week selection

Wed, 21 May 2014 12:33:30 GMT

Can you post your qvw?