topic how to use sum multiple field value in QlikView

how to use sum multiple field value

Thu, 01 Nov 2012 19:32:49 GMT

Hi,

I have requirement where I want to fetch more then one field value in to single expression.

In below mention example there is more then one division and for each division value stored on there respacted field.

I have tired single statement and found result is correct.

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

But when I am using OR I am getting -1 as value.

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

So now I am not sure my method of using OR is correct ?

CELAMBARASAN — Thu, 01 Nov 2012 19:43:42 GMT

Check with this

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

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

MayilVahanan — Thu, 01 Nov 2012 20:03:12 GMT

Try like this

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

Alt() function used because, if

sum({$<DIVISION={'L'}> GROSSWT) OR sum({$<DIVISION ={'D'}>} PCS) is null values means, may be null appear..

i.e. '-' (null value) + 45 gives null value.. to avoid this alt() function used here..

try like this

Rangesum(sum({$<DIVISION={'L'}> GROSSWT),

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

Hope it helps

Vegar — Thu, 01 Nov 2012 20:09:33 GMT

Your -1 = TRUE stating that Expression 1 OR Expression 2 are TRUE.

Not sure what you want to accomplish, but maybe this is what you want to do:

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

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab http://egbs.se