2 Replies Latest reply: Mar 20, 2017 12:42 PM by Nicholas Truss RSS

    Accumulation Help

    Nicholas Truss

      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