topic Re: Show only rows when first expression > 0 inPivot Table in QlikView

Show only rows when first expression > 0 inPivot Table

kris_vliegen — Mon, 03 Jul 2017 10:04:59 GMT

Hi all,

Is there a way to show only the rows where the value of the first Expression is > 0?

I would only see the yellow rows in my Pivot table?

regards,

Kris

prma7799 — Mon, 03 Jul 2017 10:11:57 GMT

If you have more than one column then you may be write this

if (Column(1)> 0 , Sum(sales) , Null())

Please share some sample app

MK_QSL — Mon, 03 Jul 2017 10:13:58 GMT

For each expression you have to use

If(Aantal >0, YourExpression)

kris_vliegen — Mon, 03 Jul 2017 10:18:57 GMT

Thanks,

this works. And then in the Presentation tab Suppress Zero-Values.

Regards,

Kris

prma7799 — Mon, 03 Jul 2017 10:23:32 GMT

Good...