Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ivan_will
Partner - Creator II
Partner - Creator II

Above function and full accumulation problem ?

Hi all,

please look at the attached pic below:

Capture.PNG

So the problem is :

We use full accumulation for the column Balance and want to show in column DtCt - D if column Balance is > 0 or C if it is < 0

The problem is that when we use the full accumulation it shows the numbers correctly in Balance , but when we use column(5) ot column Balance it is actually the last column without the accumulation , we have just used the above function in order to managed with the full acc. but without any success

Any idea?

1 Reply
er_mohit
Master II
Master II

for accumulation

you have to write in expression

rangesum(above(sum(fieldname),0,rowno()))