Above function and full accumulation problem ?

ivan_will — Mon, 21 Jan 2013 08:22:47 GMT

Hi all,

please look at the attached pic below:

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?

Re: Above function and full accumulation problem ?

er_mohit — Mon, 21 Jan 2013 09:03:48 GMT

for accumulation

you have to write in expression

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

topic Above function and full accumulation problem ? in QlikView

Above function and full accumulation problem ?

Re: Above function and full accumulation problem ?