Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikrambo1
Contributor III
Contributor III

=Week(quarterend(today()))

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

Labels (2)
1 Solution

Accepted Solutions
Arthur_Fong
Partner
Partner

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

 

View solution in original post

1 Reply
Arthur_Fong
Partner
Partner

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

 

View solution in original post