How to get Year of Week ISO ?

[lost_rabbit]

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.

[Qrishna]

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-IS...

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

[lost_rabbit · Accepted solution]

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/DateAnd...