Discussion Board for collaboration related to QlikView App Development.
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.
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.
please don't open multiple threads for the same question: