topic Re: Dynamic week creation in QlikView

Dynamic week creation

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dynamic week creation

Gysbert_Wassenaar — Fri, 11 Mar 2016 13:38:42 GMT

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.

Re: Dynamic week creation

MarcoWedel — Fri, 11 Mar 2016 14:29:32 GMT

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

Week creation

thanks

regards

Marco