Filter a pivot by a column expression

Tue, 09 Mar 2010 11:54:22 GMT

i have a pivot with 3 columns A,B,C and C=A-B.

i want load the row into a pivot if C>=0, is possible?

thanks

Anonymous — Tue, 09 Mar 2010 12:05:03 GMT

Could do something like


if( C>=0, C)

In this case the values which are not in the C>=0 are a null value ...

If this is the only expression the null rows shall not be displayed.

If you have other expression fields you should add the if aswell, to make the value null if not C>=0 ...

In this case this row is not displayed.

Don't know if this is what you exactly need ... and don't know if this is the nicest way of doing it ... but it could do the trick.

Anita

topic Filter a pivot by a column expression in QlikView