Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pedromsouza
Creator
Creator

Average of rows doesn't add up

Hi,

I'm working on a pivot table with an aggregated expression. For the total, I need the average of rows, but it's returning a much smaller number.

 

Sample:

Date Day Count
01/07/2021 Qui 1,866
02/07/2021 Sex 840
03/07/2021 Sáb 898
04/07/2021 Dom 122
05/07/2021 Seg 1,907
06/07/2021 Ter 1,838
07/07/2021 Qua 1,918
Avg 303

Avg should be 1,341.28 instead of 303

The expression is:

Sum(Aggr(Count({<ind_smm={'E','L'}>} Distinct p_id)
,date,venue,weekday)
)

Dimensions:

date(date)

weekday

 

Please help me figure this out!

 

Qliking since '09
1 Reply
PiEye
Contributor III
Contributor III

Hi Pedro -can you also share the expression in the first table (the non-aggregated one?)?

Your expression should work, so I wonder if it is the opposite, something to do with distinct count etc.