topic Re: Remove row from Straight Table if one expression equals 0 in QlikView

Remove row from Straight Table if one expression equals 0

Fri, 26 Sep 2014 10:52:37 GMT

Hi,

I have a straight table that has multiple expressions included (about 6) and on each one I have the suppress 0 option enabled. What I've found though with this is that the row will only be removed if each of the expressions equals 0. Is there a way to remove the row if any one of the expressions equals 0 (or null if that's easier)?

Thanks

Re: Remove row from Straight Table if one expression equals 0/null

senpradip007 — Fri, 26 Sep 2014 10:57:11 GMT

In your expression you can use Sum([Your Field])>0 in conditional expression enabling situation.

Re: Remove row from Straight Table if one expression equals 0/null

Anonymous — Fri, 26 Sep 2014 10:59:25 GMT

For the other 5 expressions you could adjust them, by adding a suitable bit from the 6th expression that make it become zero, so that they also evaluate to 0.

You could instead do similarly for a Calculated Dimension, but I would not personally do that for performance reasons.

Re: Remove row from Straight Table if one expression equals 0

anbu1984 — Fri, 26 Sep 2014 11:09:17 GMT

Check this

Re: Remove row from Straight Table if one expression equals 0

Fri, 26 Sep 2014 13:41:00 GMT

I've added in a bit to the expression calculation that checks the value in question, and make it 0 when the other one is, and it works perfectly. Thank you very much for your help.