Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Accumulation Help

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

1 Solution

Accepted Solutions
MVP

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)))

2 Replies
MVP

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)))

Not applicable
Author

Absolute Legend!!

Thanks mate!!

Nick

Tags