Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Dynamic week creation

Hi,

Below is the logic which is used to get weeks,

'Week' & Ceil(Day(Date)/7) AS WeekInMonth


am getting result as

Untitled.png


which is not correct if we check with jan calender week1 having only 1 & 2 but here it shows 1 to 7 .please help me to get this.


Thanks..

2 Replies
Gysbert_Wassenaar

Please post a small qlikview document that explains what you want and what the problem is. The screenshot you posted does not show values starting with 'Week' so they cannot be the result of the expression you posted.


talk is cheap, supply exceeds demand
MarcoWedel

please don't open multiple threads for the same question:

Week creation

thanks

regards

Marco