QlikView charts show year-on-year data, and qlikview charts show year-on-year data.

QlikView charts show year-on-year data, and qlikview charts show year-on-year data.

Data preparation is as follows:

SalesData:LOADNum(ID) as ID,Date(Date) as Date,Month,Num(Year) as Year,Num(Sales) as SalesInline [ID, Date, Month, Year, Sales1, 2012-1-1, 1, 2012, 202, 2012-1-1, 2, 2012, 213, 2012-1-1, 3, 2012, 234, 2013-1-1, 1, 2013, 345, 2013-2-1, 2, 2013, 356, 2013-3-1, 3, 2013, 467, 2014-1-1, 1, 2014, 278, 2014-2-1, 2, 2014, 309, 2014-3-1, 3, 2014, 49];

Name the new line chart "Sales ,,

 

Use Month as the dimension ,:

 

Create two new expressions in the Expression tab as follows:

 

The expression of ActualSales is as follows:

=Sum({$<Year={'$(=Max(Year))'}>}Sales)

The PCPSales expression is as follows:

=Sum({$<Year={'$(=Max(Year)-1)'}>}Sales)

Click OK to generate a table, as shown in the following figure:

 

If you have any questions, please leave a message.

 

Several more topics will be written recently ::

1. display the sales data for the first 12 months of the selected time;

2. display the sales of the previous sales level;

3. Calculate the sales data for the last year.

In the chart wizard, the year-on-year growth value must be displayed. Thank you very much for your support.

Is that true?
Use two columns of data to create a column chart
Add growth rate data
Double-click the legend and delete the three characters in the series.




How to display the year-on-year growth rate in a chart