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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NashLena
Contributor
Contributor

How to exclude items out of listbox with value 0?

Hi all,

 

I'm fighting the following problem. I have about 3000 items in my listbox and many of those items give the value 0. What I want to do is to exclude the items which gives y=0. Does someone have an idea how to do this?

 

Thank you!

1 Reply
rubenmarin1

Hi @NashLena, in the list box you have many 0 values? or many values that in your expression returns 0?

You can try with: =Aggr(If([YourExpression]<>0, FieldName), FieldName)

Not good for performance but with not many data it should work ok.