Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
paolojolly
Contributor

Compare cumulative sales

Hi, I'm not very experienced in Qlikview and 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.
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
In chart for each customer i have to show two line: one for current period and one for previous period
As dimension i need to show week_year number of current period

Can someone help me?
Many thanks