topic Re: Monthly week number ! in QlikView

Monthly week number !

Tue, 28 Aug 2012 15:00:04 GMT

I've was using the week() function, but that function returns me the week number of the year.

But I've need the monthly week number.

I don't need the complete week, can be incomplete.

Example:

Any suggestions ?

Tks !

fosuzuki — Tue, 28 Aug 2012 15:12:05 GMT

maybe you can use:

=week(date) - week(monthstart(date)) + 1

chematos — Tue, 28 Aug 2012 17:42:24 GMT

= week(date) - week(monthend(addmonths(date,-1)))

Thu, 06 Sep 2012 14:51:48 GMT

if(month(weekend(data))= month(data),div(day(WeekEnd(data)),7),div(day(Weekend(data,-1)),7)+1)+1 as WeekNumber,

Anonymous — Wed, 26 Sep 2012 16:38:46 GMT

fantastic solution!

thanks

Anonymous — Wed, 06 Nov 2013 13:53:15 GMT

Just tried this and it shows that 1st July 2013 is in week 2, yet it is actually week 1.

Could you clarify.

Thanks

Phil

Anonymous — Wed, 06 Nov 2013 14:18:16 GMT

Had to use this to make it correct .....

if((week(Date) - week(monthstart(Date)) + 1)<1,1,(week(Date) - week(monthstart(Date)) + 1)) as WeekNumberInMonth,

sakthi266 — Wed, 04 Nov 2020 10:10:13 GMT

Hi,

This script fails if Weekend ie is 7th.

Eg. If 01st is Sunday and 7th is saturday and system shows this as 2nd week instead of first week. Check this out and let me know.

Regards,

Sakthivel.S