Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

avg calculation?

Hi pls tell me

Capture.PNG.png

3 Replies
JonnyPoole
Former Employee
Former Employee

hmmm maybe with aggr() .  Can you post a QVW and we can test and apply a solution ?

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try using Aggr() like below

=Sum(Aggr(Expression, Country))

Note: Replace Expression with your Average expression.

If not working attach some sample file.

Regards,

jagan.

SunilChauhan
Champion II
Champion II

select sum of rows for average expression  inplace of expression total

Sunil Chauhan