topic Straight table average sometimes wrong in QlikView

Straight table average sometimes wrong

markp201 — Wed, 27 Jun 2018 23:09:32 GMT

I've seen some posts on this already but not sure if my situation is the same

We have 70 rows in the column totaling 298,751 which should average to 4,267 (nearest integer)

but qlik comes up with 2,766 and when I changed the calculation to use count its 108 - not 70 as I would expect.

The average qlik is calculating is right but it's actually wrong.

Who's right ?

Lisa_P — Thu, 28 Jun 2018 01:29:44 GMT

Can you add in some proof ?

Hard to comment if you can't see it.

markp201 — Thu, 28 Jun 2018 08:57:31 GMT

See the attached for an example (exported from actual chart)

markp201 — Thu, 28 Jun 2018 09:23:18 GMT

Found a posting from HIC Totals in Charts‌ which explains how Qlik operates.

If this works, I'll post the solution.

BalaBhaskar_Qlik — Thu, 28 Jun 2018 11:28:59 GMT

May be like:

Sum(Sales) / Count(Distinct Sales)... And change the options.

Or.

Sum(Aggr(Sum(Sales),Product)) / Count(Distinct Sales).