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

Gauge question

Hi guys,

Can you help me with this? I've created a gauge that includes a 0-5 rating. However, I'd like to exclude the 0 ratings in the average? How do I do it? Thanks 

2015-09-23_2030.png

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you can use

avg({<Humorrating={">0"}>}Humorrating)

Not applicable
Author

Perfekt thanks alot

skaredovs
Partner - Creator
Partner - Creator

or avg(if(Humorrating>0,Humorrating))

lironbaram
Partner - Master III
Partner - Master III

great it helps

please mark the discussion answered so other people will know