What I am doing wrong do get a correct Average and Median in QV?

[nenadvukovic]

Hi,

I hope someone can help me out here. I do not get correct Average and Median numbers for a simple case of two prices in 8 rows.

For example:

Date          Price

04.01.2016 70.88

14.01.2016 70.88

20.01.2016 70.88

21.01.2016 70.88

08.02.2016 68.60

22.02.2016 68.60

07.03.2016 68.60

14.03.2016 68.60

and I get an Average of 69.67 and Median of 68.60 instead of 69.74 for both.

I use this expression to get the average: aggr(avg(Price), F1, F2)

Thanks

[nenadvukovic]

Sorry. You are correct about this one. I am just confused between results I get in QV and Excel for Average and Median.

Henric's post also brings in confusion that

If you want to display an average number of something in QlikView, you should use the Avg() function, right?

Wrong.

I just want to display to users Average and Median Price only for certain dimensions. In the end I decided to use just avg(distinct Price) and not the Median due to incorrect results.

Thanks

[swuehl]

An average calculation using avg() is not wrong per se, Henric's point is that you need to be clear about what he calls

"implicit internal grouping entity".

What is this entity in your chart?