Dynamic week creation

[nareshthavidishetty]

Hi,

Below is the logic which is used to get weeks,

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

am getting result as

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

[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.

[MarcoWedel]

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

Week creation

thanks

regards

Marco