Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>;
Can you post your qvw?