Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik Sense Query : Retaining value in an measure

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.

1 Reply

Re: Qlik Sense Query : Retaining value in an measure

Try using the inter-record functions like after() and first(): after(count(X))-first(count(X))


talk is cheap, supply exceeds demand