Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pk11
Contributor
Contributor

Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset

Hi Team,

As per attached excel I Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset

For example 

For Fiscalweekoffset 11 and 12  the calenderweeknumberid 202226,

My requirement is for  fiscalweekoffset 11  the calenderweeknumberid  should be 202226,

and for  fiscalweekoffset 12  the calenderweeknumberid  should be 202227.

just for information, Since fiscal year starts from jul1 2022 to jun 30 2023 that's why new fiscalweekoffset is added.

Regards

Prashant

Labels (1)
0 Replies