topic Aggregated column as Input in Next Formula in QlikView https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87203#M602327 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have following problem:</P><P></P><P>I would like to use the accumulated Result in "Zert" (see picture) and subtract it from "Alle" . Unfortunately Qlikview doesn’t uses the aggregated value in each row rather the simple formula result.</P><P></P><P>In “Zert” I would like have accumulate each month to the next and so on.</P><P></P><P>Regards,</P><P></P><P>In Zert as example I would like to have:</P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Zert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alle-Zert </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 565</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 605&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 593&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 612&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 591</P><P></P><P>Month 2 Zert is Count(Zert) Month 1 + Month 2</P><P>Month 3 Zert is Count(Zert) Month 1 + Month 2 + Month 3</P><P>...</P></BODY></HTML> Wed, 15 Aug 2018 11:40:48 GMT mmainiero 2018-08-15T11:40:48Z Aggregated column as Input in Next Formula https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87203#M602327 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have following problem:</P><P></P><P>I would like to use the accumulated Result in "Zert" (see picture) and subtract it from "Alle" . Unfortunately Qlikview doesn’t uses the aggregated value in each row rather the simple formula result.</P><P></P><P>In “Zert” I would like have accumulate each month to the next and so on.</P><P></P><P>Regards,</P><P></P><P>In Zert as example I would like to have:</P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Zert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alle-Zert </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 565</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 605&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 593&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 612&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 591</P><P></P><P>Month 2 Zert is Count(Zert) Month 1 + Month 2</P><P>Month 3 Zert is Count(Zert) Month 1 + Month 2 + Month 3</P><P>...</P></BODY></HTML> Wed, 15 Aug 2018 11:40:48 GMT https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87203#M602327 mmainiero 2018-08-15T11:40:48Z Re: Aggregated column as Input in Next Formula https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87204#M602328 <HTML><HEAD></HEAD><BODY><P>Try this for the last expression</P><P></P><P><STRONG>RangeSum(Column(1), -RangeSum(Above(Count(DISTINCT Zertifizierte_NB), 0, RowNo())))</STRONG></P></BODY></HTML> Wed, 15 Aug 2018 11:50:20 GMT https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87204#M602328 sunny_talwar 2018-08-15T11:50:20Z Re: Aggregated column as Input in Next Formula https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87205#M602329 <HTML><HEAD></HEAD><BODY><P>Thank you! That is exactly what I was looking for.</P></BODY></HTML> Wed, 15 Aug 2018 11:55:20 GMT https://community.qlik.com/t5/QlikView/Aggregated-column-as-Input-in-Next-Formula/m-p/87205#M602329 mmainiero 2018-08-15T11:55:20Z