topic Re: How do I filter out 0 values in QlikView

How do I filter out 0 values

Tue, 24 Nov 2015 09:50:31 GMT

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?

Re: How do I filter out 0 values

ashfaq_haseeb — Tue, 24 Nov 2015 13:20:39 GMT

Hi,

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

Regards

ASHFAQ

Re: How do I filter out 0 values

Anonymous — Tue, 24 Nov 2015 13:20:43 GMT

On the Presentation tab try ticking Suppress Zero-Values.

Re: How do I filter out 0 values

Mark_Little — Tue, 24 Nov 2015 13:21:05 GMT

Hi,

Properties > presentation tab .

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

Mark

Re: How do I filter out 0 values

Tue, 24 Nov 2015 13:41:30 GMT

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...

Re: How do I filter out 0 values

ashfaq_haseeb — Wed, 25 Nov 2015 05:42:08 GMT

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

Re: How do I filter out 0 values

Wed, 25 Nov 2015 05:54:04 GMT

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

Re: How do I filter out 0 values

tresB — Wed, 25 Nov 2015 06:02:48 GMT

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

Re: How do I filter out 0 values

Wed, 25 Nov 2015 06:19:34 GMT

Hi Tresesco,

Sorry.

I thought it is a straight table .

Re: How do I filter out 0 values

tresB — Wed, 25 Nov 2015 06:25:53 GMT

Hi,

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

Re: How do I filter out 0 values

Wed, 25 Nov 2015 06:30:21 GMT

Its true... I never realized this ..

Will keep a note of this . Thanks