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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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()))