Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Number of weeks in a months

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.

Kindly help.

2 Replies

Re: Number of weeks in a months

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

Esteemed Contributor

Re: Number of weeks in a months


try this: