Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

matthewp
Contributor III

Straight table - hide rows where expression(s) equal value

I have a straight table and it has 13 dimensions and 4 expressions

The expressions are

=ANET-BNET

=AVAT-BVAT

=AGROSS-BGROSS

I want to hide all rows where ANET-BNET = 0 OR AVAT-BVAT = 0 OR AGROSS-BGROSS = 0

1 Solution

Accepted Solutions

Re: Straight table - hide rows where expression(s) equal value

So try this:

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, ANET-BNET)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AVAT-BVAT)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AGROSS-BGROSS)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, 4th Expression)

You mentioned 4 expressions, not sure if you have 3 or 4, but if you have the 4th, then add the same condition to the 4th expression also

1 Reply

Re: Straight table - hide rows where expression(s) equal value

So try this:

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, ANET-BNET)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AVAT-BVAT)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, AGROSS-BGROSS)

If(ANET-BNET <> 0 OR AVAT-BVAT <> 0 OR AGROSS-BGROSS <> 0, 4th Expression)

You mentioned 4 expressions, not sure if you have 3 or 4, but if you have the 4th, then add the same condition to the 4th expression also