Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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
ashfaq_haseeb
Champion III
Champion III

Hi,

Make sure suppress zero values is selected for all your expressions.

Regards

ASHFAQ

Anonymous
Not applicable
Author

On the Presentation tab try ticking Suppress Zero-Values.

Mark_Little
Luminary
Luminary

Hi,

Properties > presentation tab .

In the bottom left there is a tick box suppress zero values.

Mark

Not applicable
Author

I ticked the box of the relevant expressionScreenshot_3.png

But my straight table still looks like this

Screenshot_4.png

Any thoughts? This is the expression that I use...

Screenshot_2.png

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you share you application.

You can even try by uncheck show all values for all your dimensions.

Let me know if that fixed.

Else share your sample app to look over.

Regards

ASHFAQ

Not applicable
Author

Can you check if suppress zero values option is activated for both the dimensions and the expressions.

Also can convert the values from integer to floating digits to check whether the value is actually zero or not?

Thanks

Khushboo

tresesco
MVP
MVP

'Supress Zero-Values' is universal for a chart and you can't make it specifically enable for one or more expressions/dimensions.

Hi Marc,

          Could you post a sample qvw that demonstrates the issue?

Not applicable
Author

Hi Tresesco,

Sorry.

I thought it is a straight table .

tresesco
MVP
MVP

Hi,

It's nothing to be sorry about, we all are sharing and learning here.     It's even true for straight table.