Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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