Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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