4 Replies Latest reply: Apr 14, 2017 9:18 AM by Marloes Decraemer RSS

    how to compair values

    Marloes Decraemer

      Hi, very new to qlik!

       

      I'm looking for the way to compair values between two years.

       

      I have a table with the area of parcels in 2006 and 2016 and I want to know how much the sum of the area for each zone has changed

       

      area

      areazoneparcelyear
      20xa2016
      30xa2006
      60yb2016
      40yb2006
      10xc2016
      10xc2006

       

       

      Could you tell me how to write the function to get " sum(area zone x 2016)- sum (area zone x 2006) " per parcel. and to be able to use this as a mesurement  (if that is the right translation)

       

      Thank you so much, i feel if I get this i'll be able to do so much more and I'm having a hard time finding it in the help recources.