topic How to get the accumulation numbers in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224856#M77219 <HTML><HEAD></HEAD><BODY><P>I don't know if I good understand... but perhaps that...</P><P>Sample table: dimension date(min(datestart),'YYYY-MM')</P><P>expression count(enddate)...</P></BODY></HTML> Tue, 22 Feb 2011 13:45:16 GMT 2011-02-22T13:45:16Z How to get the accumulation numbers https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224853#M77216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following table:</P><P>OrderId StartDate EndDate</P><P>1 2010-1-1 2010-2-1</P><P>1 2010-2-3 2010-3-1</P><P>2 2010-1-1 2010-5-1</P><P>The orderId is allowed duplicate because the valid date range is different.</P><P>Now I want to get the following forms and use pivot to show.</P><P>OrderId Min StartDate Month Count</P><P>1 2010-1 2</P><P>2 2010-1 1</P><P></P><P>How to achieve it?</P></BODY></HTML> Tue, 22 Feb 2011 10:49:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224853#M77216 2011-02-22T10:49:14Z How to get the accumulation numbers https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224854#M77217 <HTML><HEAD></HEAD><BODY><P>Straight table like this:</P><P>orderid date(min(startdate),'YYYY-MM') count(enddate)</P></BODY></HTML> Tue, 22 Feb 2011 11:16:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224854#M77217 2011-02-22T11:16:21Z How to get the accumulation numbers https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224855#M77218 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply.</P><P>If I don't want to show the OrderId,</P><P>The results like this</P><P>Min StartDate Month Count</P><P>2010-1 3</P><P>If the min month is the same, I want to merge them into one month, and also show the total count in the count column.</P><P>Is it possible?</P><P>Thanks.</P><P></P></BODY></HTML> Tue, 22 Feb 2011 13:26:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224855#M77218 2011-02-22T13:26:48Z How to get the accumulation numbers https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224856#M77219 <HTML><HEAD></HEAD><BODY><P>I don't know if I good understand... but perhaps that...</P><P>Sample table: dimension date(min(datestart),'YYYY-MM')</P><P>expression count(enddate)...</P></BODY></HTML> Tue, 22 Feb 2011 13:45:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-accumulation-numbers/m-p/224856#M77219 2011-02-22T13:45:16Z