topic Calculate Difference off of two measures in QlikView

Calculate Difference off of two measures

megan_deboer — Fri, 06 Oct 2017 20:07:48 GMT

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

Re: Calculate Difference off of two measures

swuehl — Fri, 06 Oct 2017 21:54:18 GMT

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

Re: Calculate Difference off of two measures

effinty2112 — Sat, 07 Oct 2017 11:45:26 GMT

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