topic Re: How to get Year of Week ISO ? in App Development

How to get Year of Week ISO ?

lost_rabbit — Mon, 28 Oct 2024 18:31:11 GMT

How to get the Year corresponding to ISO Week?

For Eg. Year of 12/30/2024 and 12/31/2024 should be 2025 as those days fall under ISO week 1 of 2025.

In my app, I need the ISO year for multiple days such as
Year(currentday), year(currentday+7) , year(currentday+14) etc.

In snowflake there is a function called YEAROFWEEKISO, but couldn't find something similar in Qlik. Kindly help.

Thanks in advance.

Re: How to get Year of Week ISO ?

Qrishna — Tue, 29 Oct 2024 07:31:13 GMT

the weekname shuld be able to give the correct Weekname but you gotta set variables as in :

https://community.qlik.com/t5/Official-Support-Articles/QlikView-WeekName-shows-wrong-week-number-ISO-8601/ta-p/1914509

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInterpretationVariables/BrokenWeeks.htm

Re: How to get Year of Week ISO ?

lost_rabbit — Wed, 06 Nov 2024 17:13:38 GMT

weekyear() function gave me the results I wanted. Also had to set these variable values in my script

Set FirstWeekDay=0;
Set BrokenWeeks=0; //(use unbroken weeks)
Set ReferenceDay=4;

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekyear.htm