Qlik Sense Query : Retaining value in an measure

Tue, 06 Dec 2016 08:46:50 GMT

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.

Re: Qlik Sense Query : Retaining value in an measure

Gysbert_Wassenaar — Tue, 06 Dec 2016 12:43:00 GMT

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

topic Qlik Sense Query : Retaining value in an measure in App Development

Qlik Sense Query : Retaining value in an measure

Re: Qlik Sense Query : Retaining value in an measure