topic accumulate in QlikView https://community.qlik.com/t5/QlikView/accumulate/m-p/270667#M101522 <HTML><HEAD></HEAD><BODY><P>Hello all.</P><P>I can not accumulate.<BR />Does anyone have an idea?</P></BODY></HTML> Thu, 12 Jan 2012 11:46:49 GMT Anonymous 2012-01-12T11:46:49Z accumulate https://community.qlik.com/t5/QlikView/accumulate/m-p/270667#M101522 <HTML><HEAD></HEAD><BODY><P>Hello all.</P><P>I can not accumulate.<BR />Does anyone have an idea?</P></BODY></HTML> Thu, 12 Jan 2012 11:46:49 GMT https://community.qlik.com/t5/QlikView/accumulate/m-p/270667#M101522 Anonymous 2012-01-12T11:46:49Z accumulate https://community.qlik.com/t5/QlikView/accumulate/m-p/270668#M101523 <HTML><HEAD></HEAD><BODY><P>You probably want to accumulate across column segment (year)?</P><P></P><P>=rangesum(Above(total sum(VENDA),0,RowNo(total)))</P></BODY></HTML> Thu, 12 Jan 2012 11:50:47 GMT https://community.qlik.com/t5/QlikView/accumulate/m-p/270668#M101523 swuehl 2012-01-12T11:50:47Z accumulate https://community.qlik.com/t5/QlikView/accumulate/m-p/270669#M101524 <HTML><HEAD></HEAD><BODY><P>I want to cumulate regardless of the DIMENSION.</P><P> This function did not work.</P><P></P><P>=rangesum (Acima (soma total (VENDA), 0, RowNo (total)))</P></BODY></HTML> Thu, 12 Jan 2012 15:45:44 GMT https://community.qlik.com/t5/QlikView/accumulate/m-p/270669#M101524 Anonymous 2012-01-12T15:45:44Z Re: accumulate https://community.qlik.com/t5/QlikView/accumulate/m-p/270670#M101525 <HTML><HEAD></HEAD><BODY><P>I haven't suggested to use the function you are stating.</P><P></P><P>Please see attached. Is this what your want (using my above expression)?</P></BODY></HTML> Thu, 12 Jan 2012 15:49:46 GMT https://community.qlik.com/t5/QlikView/accumulate/m-p/270670#M101525 swuehl 2012-01-12T15:49:46Z accumulate https://community.qlik.com/t5/QlikView/accumulate/m-p/270671#M101526 <HTML><HEAD></HEAD><BODY><P>It worked now.</P><P>Thank you.</P><P></P><P></P><P></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 9pt;">rangesum(Above(total sum(VENDA),0,RowNo(total)))</SPAN></P></BODY></HTML> Thu, 12 Jan 2012 15:50:14 GMT https://community.qlik.com/t5/QlikView/accumulate/m-p/270671#M101526 Anonymous 2012-01-12T15:50:14Z