=Week(quarterend(today()))

[qlikrambo1]

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 · Accepted solution]

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 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Thanks and regards,

Arthur Fong