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

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

alexbjorlig — Thu, 29 Oct 2015 15:37:57 GMT

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

settu_periasamy — Fri, 30 Oct 2015 03:50:28 GMT

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

alexbjorlig — Fri, 30 Oct 2015 07:54:19 GMT

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

jagan — Fri, 30 Oct 2015 08:05:49 GMT

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

Fri, 30 Oct 2015 08:32:59 GMT

What is wrong with if statements?

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

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

alexbjorlig — Mon, 02 Nov 2015 07:46:36 GMT

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

Mon, 02 Nov 2015 10:19:15 GMT

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