topic Re: ABOVE() Function Count parameter not working in QlikView https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583270#M216617 <HTML><HEAD></HEAD><BODY><P>If you want to accumulate you probably want to use the rangesum function. Something like:</P><P>rangesum(ABOVE(SUM(Expression1), 0, ROWNO()))</P><P></P><P>Or enable the Full Accumulation option for the expression in the Accumulation section on the Expressions tab.</P></BODY></HTML> Wed, 30 Apr 2014 19:42:29 GMT Gysbert_Wassenaar 2014-04-30T19:42:29Z ABOVE() Function Count parameter not working https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583268#M216615 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am unable to get the ABOVE function to work with the count parameter. I have attached a sample Second expression should fully accumulate from the top. I was able to do this some time ago, probably with earlier version of QlikView, but am unable now.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 30 Apr 2014 19:34:24 GMT https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583268#M216615 d_pranskus 2014-04-30T19:34:24Z Re: ABOVE() Function Count parameter not working https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583269#M216616 <HTML><HEAD></HEAD><BODY><P>RangeSum(Above(SUM(Expression1),0,ROWNO()))</P></BODY></HTML> Wed, 30 Apr 2014 19:41:27 GMT https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583269#M216616 MK_QSL 2014-04-30T19:41:27Z Re: ABOVE() Function Count parameter not working https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583270#M216617 <HTML><HEAD></HEAD><BODY><P>If you want to accumulate you probably want to use the rangesum function. Something like:</P><P>rangesum(ABOVE(SUM(Expression1), 0, ROWNO()))</P><P></P><P>Or enable the Full Accumulation option for the expression in the Accumulation section on the Expressions tab.</P></BODY></HTML> Wed, 30 Apr 2014 19:42:29 GMT https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583270#M216617 Gysbert_Wassenaar 2014-04-30T19:42:29Z Re: ABOVE() Function Count parameter not working https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583271#M216618 <HTML><HEAD></HEAD><BODY><P>That's what I have been missing</P></BODY></HTML> Wed, 30 Apr 2014 20:24:44 GMT https://community.qlik.com/t5/QlikView/ABOVE-Function-Count-parameter-not-working/m-p/583271#M216618 d_pranskus 2014-04-30T20:24:44Z