topic Re: report with accumulation in QlikView https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558728#M208539 <HTML><HEAD></HEAD><BODY><P>Ty for rapid answer</P></BODY></HTML> Mon, 02 Sep 2013 10:07:13 GMT 2013-09-02T10:07:13Z report with accumulation https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558726#M208537 <HTML><HEAD></HEAD><BODY><P>I have table of users as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Login</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">date_register (mm-dd-yyyy)</TH></TR><TR><TD style="padding: 2px;">user1</TD><TD style="padding: 2px;">01-01-2013</TD></TR><TR><TD style="padding: 2px;">user2</TD><TD style="padding: 2px;">01-02-2013</TD></TR><TR><TD style="padding: 2px;">user3</TD><TD style="padding: 2px;">01-01-2013</TD></TR><TR><TD style="padding: 2px;">user4</TD><TD style="padding: 2px;">01-02-2013</TD></TR><TR><TD style="padding: 2px;">user5</TD><TD style="padding: 2px;">01-03-2013</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>I need to make report as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date <SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">(mm-dd-yyyy)</SPAN></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Count of users</TH></TR><TR><TD style="padding: 2px;">01-01-2013</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">01-02-2013</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">01-03-2013</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>If i select '01-02-2013' and '01-03-2013', i want to see this report as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date <SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">(mm-dd-yyyy)</SPAN></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Count of users</TH></TR><TR><TD style="padding: 2px;">01-02-2013</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">01-03-2013</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P></P><P>How i may make it? (If i check accumulation checkbox in expression i have counts of user for 01-02-2013 = 2 and for 01-03-2013=3 )</P></BODY></HTML> Mon, 02 Sep 2013 09:24:24 GMT https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558726#M208537 2013-09-02T09:24:24Z Re: report with accumulation https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558727#M208538 <HTML><HEAD></HEAD><BODY><P>You can use rangesum(above(count(FIELD),0,rowno())) to emulate the full aggregation, and then add advanced aggregation to limit the values to your selection (this requires that your date field's load order is sorted chronologically, as in your sample data).</P><P></P><P>See attached.</P></BODY></HTML> Mon, 02 Sep 2013 09:52:37 GMT https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558727#M208538 swuehl 2013-09-02T09:52:37Z Re: report with accumulation https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558728#M208539 <HTML><HEAD></HEAD><BODY><P>Ty for rapid answer</P></BODY></HTML> Mon, 02 Sep 2013 10:07:13 GMT https://community.qlik.com/t5/QlikView/report-with-accumulation/m-p/558728#M208539 2013-09-02T10:07:13Z