Calculate Difference off of two measures

[megan_deboer]

Hi:

I'm doing a calculation within the measure to find a performance percentage (verification rate) month to month. I'm wondering if its possible to make a column in a table averaging the variance between the months of the year.

Jan- Verification Rate

Feb- Verification Rate

Mar- Verification Rate

Difference between Jan and Feb = 5% and the difference between Feb and Mar = 15%. The average variance is = 10%?

Is this possible in Qlik Sense Desktop? I'm very new to writing calculations so appreciate any help.

Thank you!

Megan

[swuehl]

You can use chart inter record functions for that.

Create a table chart with your month dimension (sorted by month ascending) and your rate measure as expression (assuming =Sum(FIELD) )

The percentage increase could be calculated like

=Sum(FIELD) / Above(Sum(FIELD)) -1

Above - chart function ‒ Qlik Sense

[effinty2112]

Hi Megan,

This isn't so much a Qlik question as a maths question and we need to be careful. If a qty increases 5% from Jan to Feb then increases a further 15% Feb to Mar then the total increase is not 20% of the starting value but 20.75%.

100 => 105 => 120.75

So is the average growth rate half of 20.75%? No, it's not.

If we understand the average to mean the equivalent constant growth each month to achieve the actual then the "average" is around 9.886%.

Cheers

Andrew