# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted 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

Tags (2)
1 Solution

Accepted Solutions MVP

## Re: Accumulation Help

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

## Re: Accumulation Help

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

## Re: Accumulation Help

Absolute Legend!!

Thanks mate!!

Nick