Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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