Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QS does not support Full Accumulation

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

3 Replies

Re: QS does not support Full Accumulation

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

Something like:

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


http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/ChartFunctions/RangeFunctions...


paulyeo11
Valued Contributor II

Re: QS does not support Full Accumulation

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

Re: QS does not support Full Accumulation

Ok Good luck and let us know the result.