3 Replies Latest reply: Sep 11, 2012 10:48 AM by Carter James RSS

    subtracting 'cross horizontal' in pivot table?

      Hi Guys,

       

      I have a similar pivot table below. On the first colum are 2 expressions all the headers repesent the dimension year

       

       

      Expressions2008
      2009201020112012
      sum (investments)180.000178000152.000104.88493.021
      sum (investments) - (expenses)170.000168.000148.000100.00090.000
      Difference between next year?200020.00048.00010.000-

       

      Now I would like to create an expression that does the following:

       

      sum (investments) - (expenses) of 2008 - sum (investments) - (expenses) of 2009  (170.000 - 168.000) = 2000

      sum (investments) - (expenses) of 2009 - sum (investments) - (expenses) of 2010  (168000 - 148000)=20.000

      sum (investments) - (expenses) of 2010 - sum (investments) - (expenses) of 2011 (148000 - 100.000)=48.000

      sum (investments) - (expenses) of 2011 - sum (investments) - (expenses) of 2012 (100.000 - 90.000)= 10.000

       

      Is this possible within Qlikview?

       

      Thanks in advance!

       

      Carter.