Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calender week selection

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

2 Replies
Specialist III
Specialist III

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

Not applicable

Can you post your qvw?