sum

[upaliwije]

Hi

In my data model I have following records

Claim No	amount
100	1000
100	2500
101	14000
102	4500
103	2000
102	5000
101	12000
100	500

In my straight I want to sum amount by Claim No and show the results where Amount is<25000. I have written the following expression but it is not working

SUM(if(sum(amount)<25000,amount))

My expected result should be

Claim No	amount
100	4000
102	9500
103	2000

[qlikviewwizard]

Hi

Please use the below expression.

if(sum(amount)<'25000',sum(amount))