Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Can you add in some proof ?
Hard to comment if you can't see it.
See the attached for an example (exported from actual chart)
Found a posting from HIC Totals in Charts which explains how Qlik operates.
If this works, I'll post the solution.
May be like:
Sum(Sales) / Count(Distinct Sales)... And change the options.
Or.
Sum(Aggr(Sum(Sales),Product)) / Count(Distinct Sales).
