Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding zeros from Averages in a table

Hello,

I was wondering if it was possible to exclude zeros when trying to get the average of a column in a table . Currently the average is including the Zeros ($) making the figure innacurate. Please help.

Thanks,

Kevin

1 Reply
danielrozental
Master II
Master II

You could try

Avg({<Value-={0}>}Value)

or

Avg(if(Value>0,Value))