topic Re: sum in QlikView

sum

upaliwije — Wed, 29 Jul 2015 05:56:10 GMT

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

Re: sum

sushil353 — Wed, 29 Jul 2015 06:01:52 GMT

Hi,

You can simply use dimension limit functionality:

chart property>DimensionLimit

check for show only value that are > Less than > 25000 >exact amount

HTH

Sushil

Re: sum

avinashelite — Wed, 29 Jul 2015 06:06:34 GMT

try like this :

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

Re: sum

Kushal_Chawda — Wed, 29 Jul 2015 06:10:19 GMT

Expression:

Sum({<[Cliam No] ={"=sum(Amount)<25000"}>}Amount)

Re: sum

upaliwije — Wed, 29 Jul 2015 06:11:55 GMT

It is not working

Re: sum

tresB — Wed, 29 Jul 2015 06:16:24 GMT

Sum({<[Claim No]={"=sum(Amount)<25000"}>}Amount)

Re: sum

avinashelite — Wed, 29 Jul 2015 06:17:40 GMT

its working for me !!! need to check your data once , can you please share your app.

Pleas find the attachment

Re: sum

upaliwije — Wed, 29 Jul 2015 06:17:58 GMT

Thanks

Is does not give desired results. Can u pls test this and reply with the sample QV doc

Re: sum

Kushal_Chawda — Wed, 29 Jul 2015 06:22:25 GMT

I had modified it

Re: sum

upaliwije — Wed, 29 Jul 2015 06:26:36 GMT

Thanks all of u

Re: sum

qlikviewwizard — Wed, 29 Jul 2015 06:44:39 GMT

Please use the below expression.

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