Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead 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
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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