Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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