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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I filter out 0 values

Guys,

I have a column with age values called "AGE". I listed them in a straight table. I then created input variables where I can enter the minimal (ageDown) and maximum (ageUp) age

   Sum({<AGE={">=$(ageDown)<=$(ageUp)"}>} AGE)

Screenshot_2.png

The straight table now shows all values which have an age between the parameters I entered. Works fine, only one problem: I also see 0 values.

Is there a way in which I can get rid of them?

Screenshot_1.png

10 Replies
Not applicable
Author

Its true... I  never realized this ..

Will keep a note of this . Thanks