topic Re: Suppressing null values-expression in QlikView

Suppressing null values-expression

Mon, 16 Jan 2017 11:30:59 GMT

I have a straight table.

Dimension: Product code

Expressions:

Sum(Free stock)

Sum(Month 24)

Sum(Month 25)

Sum(Total Value 24 + 25)

If Month 24 column has a value greater than 0 then I'd like it to appear in the table. If the value = 0 then I would not like the row to appear (even if there's data in the other expressions).

I know there is "suppress null values" within a dimension, but is there the option for an expression?

Please can you help?

thanks

Re: Suppressing null values-expression

khalander — Mon, 16 Jan 2017 12:29:48 GMT

In Presentation Tab you can check suppress Zero values

Re: Suppressing null values-expression

Mon, 16 Jan 2017 12:30:58 GMT

Hi Gemma,

With selecting "conditional" for this expression (in the expression tab), and applying ...>0 or not(isnull(...), this column will disappear as you want.

Re: Suppressing null values-expression

avinashelite — Mon, 16 Jan 2017 12:32:14 GMT

Go to Chart Properties >Presentation > Suppress Zero values

Re: Suppressing null values-expression

Mon, 16 Jan 2017 12:32:19 GMT

Thanks, but this does not remove the zero values from the expressions. It's checked and I still have 0's.

Re: Suppressing null values-expression

Mon, 16 Jan 2017 15:43:49 GMT

Thanks, but this does not remove the zero values from the expressions. It's checked and I still have 0's.

Re: Suppressing null values-expression

Mon, 16 Jan 2017 16:41:05 GMT

thanks, but I do not require the column to disappear, I'd like the rows to disappear if they are populated with a 0 value within this column

Re: Suppressing null values-expression

MarcoWedel — Mon, 16 Jan 2017 21:40:52 GMT

Hi,

maybe like this:

Dimension: Product code

Expressions:

If(Sum(Month 24), Sum(Free stock))

Sum(Month 24)

If(Sum(Month 24), Sum(Month 25))

If(Sum(Month 24), Sum(Total Value 24 + 25))

(+suppress zero values)

hope this helps

regards

Marco

Re: Suppressing null values-expression

Tue, 17 Jan 2017 08:15:38 GMT

Thank you, that's worked.

Re: Suppressing null values-expression

MarcoWedel — Tue, 17 Jan 2017 17:46:23 GMT

You're welcome

Nice to hear it worked for you.

regards

Marco