6 Replies Latest reply: Nov 2, 2015 5:19 AM by Harry Stam

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

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!

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

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)

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

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

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

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.

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

What is wrong with if statements?

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

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

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.

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

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