topic Re: Calculating Variance for KPI in QlikView

Calculating Variance for KPI

Wed, 25 Nov 2020 16:16:04 GMT

Hello Community,

I'm looking to make a simple variance KPI beneath the KPI numbers i've got, comparing current and last year numbers and showing the difference in %.

Current year expression:

Sum({<AAR={$(=Max(AAR))}>}ARBLED)

Last year Expression:

Sum({<AAR={$(=Max(AAR)-1)}>}ARBLED)

AAR in the expression above is a year field in my data set.

I tried to simply divide last year with current year. However my output isn't the same numbers calculated normally at all (which could give me say 0,9, and therefore the difference would be -0,1(-10%).

I basically want to show it this way, only missing the variance:

Best regards,

Mark J

Re: Calculating Variance for KPI

sunny_talwar — Tue, 29 Nov 2016 23:29:25 GMT

So you are saying that your numbers from the two expressions are incorrect? Because 17.96/46.62 = 38.52% or 39%, Right?

Re: Calculating Variance for KPI

Tue, 29 Nov 2016 23:33:14 GMT

Sorry - the photo is kinda misguiding, i took it from another post, from which the answers were only regarding comparing months.

I however got it done right now by using the expression:

Last Month expression / current month expression * 100-100

Not sure if it's allright to do it that way, format wise and if maybe the *100-100 could give me problems at some point? if there's a better way to do it please say so? but it does the job at least.

Re: Calculating Variance for KPI

sunny_talwar — Tue, 29 Nov 2016 23:38:47 GMT

If you are getting the right output now, I don't see why it would be a problem at a later point. You are going to be carrying out the same operation each time. So you should be good to go

Re: Calculating Variance for KPI

Tue, 29 Nov 2016 23:41:47 GMT

Allright, Thank you for the confirmation at least