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: 
SaiVishnu
Contributor
Contributor

Same WeekDay for Current Year vs Previous Year comparison - Leap Year

I have to create a Report based on Day wise comparison of Current Year vs Previous Year. Current Year is leap Year , so it is not working as expected. Below the list of sample data for the Year 2024 vs Year 2023

SaiVishnu_1-1709720907053.png

 

SaiVishnu_2-1709721032677.png

 

But , What I am getting is incorrect

SaiVishnu_3-1709723202448.png

 

 

 

 

Labels (1)
2 Replies
Clement15
Partner - Creator III
Partner - Creator III

Hello, recreating the date like that can't solve your problem?

MakeWeekDate(Weekyear(Date)-1,Week(Date),WeekDay(Date))

SaiVishnu
Contributor
Contributor
Author

Thanks for your response.  This is not giving the expected output.