Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator
Creator

Fiscal Calendar Non Standard

Hi All,

Can you help me to create a fiscal calendar for

29-06-2018  to 05-07-2018 -start Week (Week 1)

.

.

.

.

27-06-2019 to 27-06-2019 - end Week (Week 52)

Also i need to change the Year accordingly. I tried with below and week number got changed accordingly. I Stuck with year how to change the year

Right(WeekName(REPORT_DATE,-25,4),2) as WeekNumber,

Thanks,

Gowtham

0 Replies