topic Historical Comparative Sales Analysis in QlikView https://community.qlik.com/t5/QlikView/Historical-Comparative-Sales-Analysis/m-p/151199#M29104 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We are an multi site apparel retailer that analysis our sales at very detailed level.</P><P>We like to monitor our comparative sales by day.</P><P>We have not found a way to make the comp calculation dynamic, we have to flag stores with a comp status either yes or no. This obviously doesn't work if you try to report on a period prior to current date.</P><P>The only solution we could think of is a mapping table by store by day which we believe would have a massive performance impact as the data would have to be calculated at transaction level.</P><P>Has anyone found a solution for calculation of historical comparative sales percentages ?</P><P>Regards,</P><P>Martin</P></BODY></HTML> Thu, 06 Aug 2009 06:04:38 GMT 2009-08-06T06:04:38Z Historical Comparative Sales Analysis https://community.qlik.com/t5/QlikView/Historical-Comparative-Sales-Analysis/m-p/151199#M29104 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We are an multi site apparel retailer that analysis our sales at very detailed level.</P><P>We like to monitor our comparative sales by day.</P><P>We have not found a way to make the comp calculation dynamic, we have to flag stores with a comp status either yes or no. This obviously doesn't work if you try to report on a period prior to current date.</P><P>The only solution we could think of is a mapping table by store by day which we believe would have a massive performance impact as the data would have to be calculated at transaction level.</P><P>Has anyone found a solution for calculation of historical comparative sales percentages ?</P><P>Regards,</P><P>Martin</P></BODY></HTML> Thu, 06 Aug 2009 06:04:38 GMT https://community.qlik.com/t5/QlikView/Historical-Comparative-Sales-Analysis/m-p/151199#M29104 2009-08-06T06:04:38Z