topic Re: =Week(quarterend(today())) in QlikView

=Week(quarterend(today()))

qlikrambo1 — Sat, 16 Nov 2024 02:16:09 GMT

All,

could some one help me correcting the function

Am trying to get the number of weeks in a Quarter, for that I have subtracted first week of quarter and last week of quarter

week(QuarterStart(today())) is giving me 40 (which is expected)

week(QuarterEnd(today())) is giving me 1 (it should actually give me 53)

could some one help me in this.

thanks

Arthur_Fong — Wed, 09 Oct 2019 23:59:19 GMT

Try this:

=week(QuarterEnd(today()),6,1)

Parameter Six is to identify which is the first day of the week. 6=Sunday.

Add another parameter to have broken weeks applied to week function.

For more info, refer to

Thanks and regards,

Arthur Fong