Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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

YoussefBelloum
Esteemed Contributor

Re: Number of weeks in a months

Hi,

try this:

=week(MonthEnd(Date))-(week(MonthStart(Date))-1)