Calender week selection

[#1]

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

[senpradip007]

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>;

[#3]

Can you post your qvw?