QS does not support Full Accumulation - Qlik Community

paulyeo11 · ‎2015-10-19

Hi All

Below code work fine in QV with Full Accumulation turn on.

count(distinct(if(inv>'800000' and inv<'899999' and year,inv)))

But in QS , it does not have Accumulation.

May i know how to modify the script above ?

Paul

robert_mika · ‎2015-10-20

Look at RangeSum function if in doubt post your qvf file.

Something like:

RangeSum(Above(Count(inv),0,RowNo()))

paulyeo11 · ‎2015-10-20

Hi Robert

Thank you for give me the link , i will try out myself by read the post , in case i still unable to make it , i will post my doc here.

Paul

robert_mika · ‎2015-10-20

Ok Good luck and let us know the result.