topic Re: Expressions Limits in QlikView

Expressions Limits

Tue, 26 Feb 2013 13:48:25 GMT

I know it is possible to limit dimensions to only show value greater or less than a certain number.

I have this expression:

sum({$<[Margin Account] =>} MARGIN)

This is used in a straight table and I would like to only display values above £10, 000, 000. How would I do that?

Gysbert_Wassenaar — Tue, 26 Feb 2013 13:52:03 GMT

This will show you the sum of MARGIN where Margin Account is > 10,000,000:

sum({$<[Margin Account] = {'>10000000'} >} MARGIN)

This returns the sum of MARGIN where MARGIN is > 10,000,000 and selections in Margin Account are disregarded:

sum({$<[Margin Account]=, MARGIN={'>10000000'} >} MARGIN)

This returns a value if the sum of MARGIN is > 10,000,000:

If(sum($<[Margin Account]=>}MARGIN)>10000000),sum($<[Margin Account]=>}MARGIN)>10000000))

Not sure which one you're looking for.

Tue, 26 Feb 2013 13:55:25 GMT

i need to display the results where SUM of MARGIN > 1000000, not the MARGIN

so if it was a dimension, i could just choose to show values that are greater than 100000