topic Re: Sum of multiple field value in QlikView

Sum of multiple field value

Thu, 01 Nov 2012 20:49:59 GMT

Hi,

how to sum multiple field value into single expression.

=sum({$<DIVISION ={'L'}>} GROSSWT) OR sum({$<DIVISION ={'D'}>} PCS)

In above mention example, If I am using first part I am able to see the sum of division "L" on my expression but when I am addting OR for second value my calculation give me -1 as value.

Any idea why ? and if any other way to do that.

Re: Sum of multiple field value

swuehl — Thu, 01 Nov 2012 23:58:45 GMT

Are you maybe looking for

=sum({$<DIVISION ={'L'}>} GROSSWT) + sum({$<DIVISION ={'D'}>} PCS)

or using rangesum

=rangesum(sum({$<DIVISION ={'L'}>} GROSSWT),sum({$<DIVISION ={'D'}>} PCS) )

OR is a logical operator and will return either -1 (true) or 0 (false)

Hope this helps,

Stefan

Re: Sum of multiple field value

Fri, 02 Nov 2012 05:07:02 GMT

wat is the complete expr: any if expr ?

Re: Sum of multiple field value

kaushiknsolanki — Fri, 02 Nov 2012 05:18:14 GMT

Try this.

Sum(if(Wildmatch(DIVISION,'L'),GROSSWT,if(wildmatch(DIVISION,'D'),PCS)))

Regards,

Kaushik Solanki

Re: Sum of multiple field value

kaushiknsolanki — Fri, 02 Nov 2012 05:19:36 GMT

Try this,

Sum(if(DIVISION ='L',GROSSWT,if(DIVISION='D',PCS)))

Regards,

Kaushik Solanki

Re: Sum of multiple field value

Fri, 02 Nov 2012 05:31:33 GMT

try the below expression

=if(DIVISION='L',sum(GROSSWT),

if(DIVISION='D',sum(PCS),null()))

Re: Sum of multiple field value

Fri, 02 Nov 2012 05:41:12 GMT

below i give sample exp

if(empno=1,11,

if(empno=2,22,

if(empno=3,33,

If(empno=4,44,55)

)))

in the above exp if empno=1 then it give 11,

for 2 it show 22,for 3 give 33,for 4 give 44

otherwise give 55 for remaining values.

below is result table

Re: Sum of multiple field value

Mon, 12 Nov 2012 05:41:12 GMT

Thanks to you all.

With below mention expression I was able to get reply.

sum(if(DIVISION='D', PCS,GROSSWT))

Re: Sum of multiple field value

BrightFuture — Wed, 28 Nov 2018 09:57:01 GMT

Hey,

I am looking for this kind of sum that you have mentioned:

=sum({$<DIVISION ={'L'}>} GROSSWT) + sum({$<DIVISION ={'D'}>} PCS)

However, I noticed that the "+" is not summing it up for me. Only one of the two expressions is executed. Do you have any idea on how to sum tow sums?? I already have provided an example it would be great if you could have a look at it. The contribution title is "getting the quarters right"