topic sum not working in QlikView

sum not working

Mon, 26 Dec 2011 10:10:09 GMT

Dear all I am using

1. sum(column(1)) but it is not working

2. sum( ( ( sum( if( trnType='Sales',fld1)) - sum(if(trnType='Sales',fld2)) ) / sum(if(trnType='Sales',fld3)) ) )

this is giving syntex error

don't understand what I am doing wrong in both case

please help

Thanks & Regards

SunilChauhan — Mon, 26 Dec 2011 10:13:13 GMT

try this

sum(aggr(column(1),keyfield))

sum( aggr( ( ( sum( if( trnType='Sales',fld1)) - sum(if(trnType='Sales',fld2)) ) / sum(if(trnType='Sales',fld3)) ) ,keyfield) )

Mon, 26 Dec 2011 10:19:36 GMT

hi, Sunil

thanks for quick reply, but it is not qiving any result

I am trying case 1

a. sum(aggr(column1),unit1,partyName)

b. aggr(sum(column(1)),unit1,partyName)

both is not giving any result

SunilChauhan — Mon, 26 Dec 2011 10:59:23 GMT

can u share the sample