https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2427768#M96288 <P>Hello, recreating the date like that can't solve your problem?</P> <P>MakeWeekDate(Weekyear(Date)-1,Week(Date),WeekDay(Date))</P> Wed, 06 Mar 2024 13:25:42 GMT Clement15 2024-03-06T13:25:42Z https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2427705#M96284 <P>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</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SaiVishnu_1-1709720907053.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161428iF04CCE749F438AF6/image-size/medium?v=v2&amp;px=400" role="button" title="SaiVishnu_1-1709720907053.png" alt="SaiVishnu_1-1709720907053.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SaiVishnu_2-1709721032677.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161429i81297893E51A7E6A/image-size/medium?v=v2&amp;px=400" role="button" title="SaiVishnu_2-1709721032677.png" alt="SaiVishnu_2-1709721032677.png" /></span></P> <P>&nbsp;</P> <P>But , What I am getting is incorrect</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SaiVishnu_3-1709723202448.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161430i77C1403B2402EB34/image-size/medium?v=v2&amp;px=400" role="button" title="SaiVishnu_3-1709723202448.png" alt="SaiVishnu_3-1709723202448.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:02:22 GMT https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2427705#M96284 SaiVishnu 2024-11-15T21:02:22Z https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2427768#M96288 <P>Hello, recreating the date like that can't solve your problem?</P> <P>MakeWeekDate(Weekyear(Date)-1,Week(Date),WeekDay(Date))</P> Wed, 06 Mar 2024 13:25:42 GMT https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2427768#M96288 Clement15 2024-03-06T13:25:42Z https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2429960#M96482 <P>Thanks for your response.&nbsp; This is not giving the expected output.</P> Tue, 12 Mar 2024 16:48:10 GMT https://community.qlik.com/t5/App-Development/Same-WeekDay-for-Current-Year-vs-Previous-Year-comparison-Leap/m-p/2429960#M96482 SaiVishnu 2024-03-12T16:48:10Z