Avg vg Avg(aggr()) at chart

cmano — Wed, 21 Dec 2022 07:13:08 GMT

Hello guys.

I have the below chart.

I use this expression : Avg([Mean value]) results on the chart.

No they want to convert this chart to boxplot. I use the box plot wizard and i take this chart

I create a table to verify the values :

As you can see the mean values are not the same ( for middle measurements at least).

The expression at boxplot is : Avg(Aggr([Mean value],[Order],[Mean value]))

I create bar charts with these 2 expressions and the results are not the same.

The questions are :

Why i take different results with different expressions of average?

How i can resolve this issue? I mean boxplot avg to be the same as bar chart?

thank you.

Re: Avg vg Avg(aggr()) at chart

hic — Wed, 21 Dec 2022 07:35:31 GMT

First, you need to ask average of WHAT? Of the transactions (the individual records)? Or of the average per Order? Those are different. See https://community.qlik.com/t5/Design/Average-Which-average/ba-p/1466654

Also, I think you want a different Aggr() call. I suggest not having [Mean value] as dimension. Also, make sure that you use an inner aggregation function. Hence:

Avg(Aggr(Avg([Mean value]),[Order]))

See https://community.qlik.com/t5/Design/Pitfalls-of-the-Aggr-function/ba-p/1463275

topic Re: Avg vg Avg(aggr()) at chart in QlikView

Avg vg Avg(aggr()) at chart

Re: Avg vg Avg(aggr()) at chart