1 Reply Latest reply: Dec 6, 2016 7:43 AM by Gysbert Wassenaar RSS

    Qlik Sense Query : Retaining value in an measure

    Ardra Menon

      We are having a requirement were we need to retain a particular value in a measure for calculating rest of the fields, and we are unable to achieve that.

       

      Scenario :

       

      We have a report were we need to calculate a field “growth”. As you can see it is the difference between (month) 2016 and December 2015

       

      Eg: Mar 2016- dec 2015 = 4835-4824 = 11

       

      Month

      DEC 2015

      Jan 2016

      Feb 2016

      Mar 2016

      Apr 2016

      May 2016

      Jun 2016

      Jul 2016

      Aug 2016

      Sept 2016

      Total Count

      4,824

      4,824

      4,820

      4,835

      4,836

      4,837

      4,838

      4,833

      4,834

      4,831

      Growth

      0

      (4)

      11

      12

      13

      14

      9

      10

      7

       

       

      For this we need to retain the total count of Dec 2015 in an attribute , which we are not able to do. Can you please provide us with the syntax for this.