5 Replies Latest reply: May 10, 2016 1:36 AM by Gysbert Wassenaar RSS

    Operations pivot table in Qlik Sense

    Alex Valverde

      Good, for a query:

      in a pivot table, I have several measures for every year, I need to do the following:

       

      in expressions using:

      if (ColumnNo()=1, Column(1) + Column(2))

       

      this expression returns me the correct result because both columns belong to the same year, but need to subtract 1 column a year against the same column but another year

       

      For better detail I attached image of the pivot table.

       

      Referring to the image:

       

      The Column "Variación (2016)" = Column Accumulated (2016) - Column Accumulated (2015)

      The Column "Variación (2015)" = Column Accumulated (2015) - Column Accumulated (2014)

      The Column "Variación (2014)" = Column Accumulated (2014) - Column Accumulated (2013)

       

      Thank you for your prompt help.