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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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 - Specialist
Partner - Specialist

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.