Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppressing null values-expression

Hi

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

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

9 Replies
khalander
Creator II
Creator II

In Presentation Tab you can check suppress Zero values

Not applicable
Author

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.

avinashelite

Go to Chart Properties >Presentation > Suppress Zero values

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

MarcoWedel

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

Not applicable
Author

Thank you, that's worked.

MarcoWedel

You're welcome

Nice to hear it worked for you.

regards

Marco