How do I filter out 0 values

[#1]

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)

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?

[ashfaq_haseeb]

Hi,

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

Regards

ASHFAQ

[Anonymous]

On the Presentation tab try ticking Suppress Zero-Values.

[Mark_Little]

Hi,

Properties > presentation tab .

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

Mark

[#5]

I ticked the box of the relevant expression

But my straight table still looks like this

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

[ashfaq_haseeb]

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

[#7]

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]

'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?

[#9]

Hi Tresesco,

Sorry.

I thought it is a straight table .

[tresesco]

Hi,

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