Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Straight table average sometimes wrong

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 ?

Tags (2)
4 Replies
Highlighted
Employee
Employee

Re: Straight table average sometimes wrong

Can you add in some proof ?

Hard to comment if you can't see it.

Highlighted
Creator III
Creator III

Re: Straight table average sometimes wrong

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

Highlighted
Creator III
Creator III

Re: Straight table average sometimes wrong

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

If this works, I'll post the solution.

Highlighted

Re: Straight table average sometimes wrong

May be like:

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

Or.

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