https://community.qlik.com/t5/QlikView/Compare-weekly-comulative-sales/m-p/1557621#M456929 <P>Hi, I need help to create a line chart in whitch compare, for each customer, cumulative sales of last 52 week(starting from date set in vDataFin variable) with sales of previous period.<BR />For example if vDataFin value is 15/02/2019 current period is 16/02/2018 - 15/02/2019 and previous period is 16/02/2017 - 15/02/2017<BR />In chart for each customer i have to show two line: one for current period and one for previous period<BR />As dimension i need to show week_year number of current period</P><P>Result should be a chart like</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chart example.png" style="width: 573px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8219i675D73D99C50E0A6/image-dimensions/573x331?v=v2" width="573" height="331" role="button" title="chart example.png" alt="chart example.png" /></span></P><P>&nbsp;</P><P>Can someone help me?<BR />Many thanks</P> Sat, 16 Nov 2024 21:13:40 GMT paolojolly 2024-11-16T21:13:40Z https://community.qlik.com/t5/QlikView/Compare-weekly-comulative-sales/m-p/1557621#M456929 <P>Hi, I need help to create a line chart in whitch compare, for each customer, cumulative sales of last 52 week(starting from date set in vDataFin variable) with sales of previous period.<BR />For example if vDataFin value is 15/02/2019 current period is 16/02/2018 - 15/02/2019 and previous period is 16/02/2017 - 15/02/2017<BR />In chart for each customer i have to show two line: one for current period and one for previous period<BR />As dimension i need to show week_year number of current period</P><P>Result should be a chart like</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chart example.png" style="width: 573px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8219i675D73D99C50E0A6/image-dimensions/573x331?v=v2" width="573" height="331" role="button" title="chart example.png" alt="chart example.png" /></span></P><P>&nbsp;</P><P>Can someone help me?<BR />Many thanks</P> Sat, 16 Nov 2024 21:13:40 GMT https://community.qlik.com/t5/QlikView/Compare-weekly-comulative-sales/m-p/1557621#M456929 paolojolly 2024-11-16T21:13:40Z