Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
Creator II
Creator II

In Presentation Tab you can check suppress Zero values

Highlighted
Not applicable

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.

Highlighted

Go to Chart Properties >Presentation > Suppress Zero values

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted

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

Highlighted
Not applicable

Thank you, that's worked.

Highlighted

You're welcome

Nice to hear it worked for you.

regards

Marco