topic Retail Sales Comparison- Like to Like Week Day in QlikView https://community.qlik.com/t5/QlikView/Retail-Sales-Comparison-Like-to-Like-Week-Day/m-p/782027#M665864 <HTML><HEAD></HEAD><BODY><P>User Criteria :</P><P> Week :always starts on Friday and end on Thursday.</P><P>Store Closed Sat and Sun</P><P>Compare Current Year Week1 - Prior Year Week1</P><P>If Current Year Week 1 has 3 days of sales and Prior Year Week 1 has 5 days of sales then It should return only 3 days of sales</P><P></P><P>Week 1&nbsp;&nbsp; Current Year&nbsp;&nbsp; Prior Year&nbsp; </P><P>mon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Tue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Wed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Thur&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Friday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P></P><P>It has to compare Mon , Tue and Friday.</P><P></P><P>Table:</P><P>TransactionDate</P><P>Store</P><P>Sales Amount</P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 Dec 2014 07:01:04 GMT 2014-12-05T07:01:04Z Retail Sales Comparison- Like to Like Week Day https://community.qlik.com/t5/QlikView/Retail-Sales-Comparison-Like-to-Like-Week-Day/m-p/782027#M665864 <HTML><HEAD></HEAD><BODY><P>User Criteria :</P><P> Week :always starts on Friday and end on Thursday.</P><P>Store Closed Sat and Sun</P><P>Compare Current Year Week1 - Prior Year Week1</P><P>If Current Year Week 1 has 3 days of sales and Prior Year Week 1 has 5 days of sales then It should return only 3 days of sales</P><P></P><P>Week 1&nbsp;&nbsp; Current Year&nbsp;&nbsp; Prior Year&nbsp; </P><P>mon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Tue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Wed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Thur&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Friday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P></P><P>It has to compare Mon , Tue and Friday.</P><P></P><P>Table:</P><P>TransactionDate</P><P>Store</P><P>Sales Amount</P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 Dec 2014 07:01:04 GMT https://community.qlik.com/t5/QlikView/Retail-Sales-Comparison-Like-to-Like-Week-Day/m-p/782027#M665864 2014-12-05T07:01:04Z