Discussion Board for collaboration related to QlikView App Development.
I need to calculate the number of weeks in a specific month.
i m using a expression like
week(monthend(Date)) - week(MonthEnd(addmonths(Date,-1,0))) .
But its not giving a right answer.
Hi Pooja, Week() waits for a date to return the week number this date belongs, you can do:
Ceil((monthend(Date) - MonthStart(Date))/7) // Or Floor instead of Ceil to round down