Accumulation Help

[#1]

Hi,

I am having trouble with the RangeSum accumulation function in Qlik Sense. I've seen somewhere that you cannot accumulate with Multiple dimension is this true? At the moment I am using the below formula but it just brings up the original value.

RangeSum( 

Above(

((Sum(    {<BANK_CODE={'1210'}, DELETED_FLAG={'0'}, TYPE = {'PA' , 'PP' , 'PR' , 'SA' , 'SR' , 'SP'}      >}    GROSS_AMOUNT)*-1) 

+

(Sum(    {<BANK_CODE={'1210'}, DELETED_FLAG={'0'}, TYPE = {'JD' , 'JC' , 'BR' ,  'BP' }      >}    GROSS_AMOUNT))) 

,0, rowno()))

There is probably an easier way to do the above but as a qlik novice I'm unaware of any other way to get the required output.

Thanks,

Nick

[sunny_talwar · Accepted solution]

May be this

RangeSum(

Above(TOTAL

((Sum(    {<BANK_CODE={'1210'}, DELETED_FLAG={'0'}, TYPE = {'PA' , 'PP' , 'PR' , 'SA' , 'SR' , 'SP'}      >}    GROSS_AMOUNT)*-1)

+

(Sum(    {<BANK_CODE={'1210'}, DELETED_FLAG={'0'}, TYPE = {'JD' , 'JC' , 'BR' ,  'BP' }      >}    GROSS_AMOUNT)))

,0, rowno(TOTAL)))

[#3]

Absolute Legend!!

Thanks mate!!

Nick