QlikView chart displays year-on-year data

Prepare the following data: SalesData: LOADNum (ID) asID, Date (Date) asDate, Month, Num (Year) asYear, Num (Sales) asSalesInline [ID, Date, Month, Year, sales1, 2012-1-2012,202,201, 2012,213,201 2-1-2012,234,201, 2013,345 2-1-, 3-1,

Prepare the following data: 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,201 2-1-1 -1, 2, 2012,213,201 2-1-1, 3, 2012,234,201 3-1-1, 1, 2013,345,

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({$
 
  }Sales)
 

The PCPSales expression is as follows:

=Sum({$
 
  }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.