topic Re: Average of 2 or more variables in QlikView

Average of 2 or more variables

Anonymous — Tue, 08 May 2012 20:23:57 GMT

Hi all,

Who knows how to calculate average of 2 or more variables in a script or an expression?

Thanks in advance,

Average of 2 or more variables

swuehl — Tue, 08 May 2012 20:44:55 GMT

I think you want to have a look at the rangeavg() function. Could be used like

LOAD

rangeavg(A,B) as Average

from ...

rangeavg( $(vVal1), $(vVal2) )

Hope this helps,

Stefan

Average of 2 or more variables

Anonymous — Tue, 08 May 2012 20:53:57 GMT

You'are right.

I used rangeavg in an expression, didn't work.

Thanks,

Average of 2 or more variables

Anonymous — Tue, 08 May 2012 21:11:38 GMT

Stefan,

How does the second method work?

Regards,

Re: Average of 2 or more variables

swuehl — Wed, 09 May 2012 18:29:47 GMT

Well, it works using QV variables.

I wasn't sure what you mean with variables, since some people (like in statistics) use the term variable different from the QV usage, where it is used like in software programming (variable in contrast to constant). The term variable used in statistics would be called field or dimension / measure in QV.

Since I don't know what you are after, I posted short samples for both (maybe too short samples). So $(vVal1) and $(vVal2) evaluate the QV variables vVal1 and vVal2 respectively.

But if this does not solve your probelm, it would be more important to know what you are after, what your requirements / problems are?

Average of 2 or more variables

Anonymous — Wed, 09 May 2012 20:33:50 GMT

Thanks,

I found out.

Re: Average of 2 or more variables

kavicsgym — Wed, 28 Sep 2016 08:10:15 GMT

Hi, do you think it can be used to define the value of a reusable expression like that?

It does not work in Sense variable editor.

RangeAvg(

$(eKPI(06)), $(eKPI(07))

)

The values are monthly figures and their average should be calculated.

Thanks , Enikö

Re: Average of 2 or more variables

kavicsgym — Wed, 08 Mar 2017 11:32:46 GMT

Hi, could anyone pls. resolve my question from some month ago, I found a workaround but this would be nicer:

RangeAvg(20, 40) is the definition or my variable in Qlik sense, it works

But with a nested expression it does not work, can anyone suggest pls why?

RangeAvg

$(ePDCA_WSAuslief_Pkd_Total(01)), $(ePDCA_WSAuslief_Pkd_Total(02))

)

Those 2 expressions are complicated enough... how could I pass their value to RangeAvg?????

Thanks a lot! Enikö