topic set anaalysis help please. in QlikView

set anaalysis help please.

Mon, 03 Feb 2014 04:26:00 GMT

How can I write this in set analysis.

Sum(if(ActualAccount<>0,
if([Miscellenious Fee]<>0,FeeAmount)))

Thanks

sujeetsingh — Mon, 03 Feb 2014 04:40:38 GMT

Something like this :

sum({$<ActualAccount-={'0'},MiscelleniusFee-={'0'} >}FeeAmount)

MK_QSL — Mon, 03 Feb 2014 07:23:39 GMT

SUM({$<

ActualAmount -= {0},

[Miscellenious Fee] -= {0}

>}FeeAmount)

Mon, 03 Feb 2014 07:25:44 GMT

try this

sum({$<ActualAccount-={'0'},MiscelleniusFee-={'0'} >} FeeAmount)

**********************************************************************************