Suppress Zero-Values in straight table with two measures without if

[alexbjorlig]

Hi Qlik Community.

How can I suppress Zero-Values in a straight table, when having two measures without if statements?

If i only have one measure it works:

But when I add a second measure - I can't suppress!

I have attached the workbook...

Thanks for the awesome help!

[settu_periasamy · Accepted solution]

Hi,

That is because of your Expression 2. (you have the value in 2nd Measure). 

you can  use 'Suppress Zero-Values' in Presentation Tab.

But, In this case you should use if condition.

Like,  if(Sales>0, Sales+1)

[alexbjorlig]

I just don't understand why it is not possible to Suprress Zero-Values in all measures?

The reason I ask is because I have multiple tables, where I now have to edit many expressions.

Thanks for the help anyway

[jagan]

Hi,

To Supress zero values all expressions values should be zero, then only entire row will hide.  If you want to hide the row if first measure value is zero then use below condition for second measure

Expression1: Sum(Sales)

Expression2 = If(Sum(Sales) > 0, [Sales+1 Expression])

**Replace  [Sales+1 Expression] & Sum(Sales) with your actual expressions.

Regards,

Jagan.

[#5]

What is wrong with if statements?

(if(SUM(Sales)=0,'',sum(Sales))

[alexbjorlig]

Hi Harry. There is nothing wrong with if statements, but as I wrote I have multiple tables - and wanted a quick way to suppress zero values.

[#7]

Try the “Expression Overview” (CTRL-ALT-E) for mass update of the expressions.