Max and Avg

[anushree1]

Hi,

Could anyone please let me know how we could perform avg and max equivalent to excel in Qlikview

Ex:avg(1,2)- Must return 4,

Similarly Max(5,10) must return 10

As of my understanding Max and Avg works on the named column and returns the respective avg or max value .

But, incase i would need a comparison to be made and have a result produced based on the two values as quoted in the example.

How could that be done.

[sunny_talwar · Accepted solution]

You can use RangeMax() and RangeAvg()

=RangeAvg(1, 2) = 1.5 (not sure how you got 4)?

=RangeMax(5, 10) = 10

[anushree1]

Sorry My bad its 1.5 .

Thanks for the reply