topic Re: Creating an accumulating count by date in a line chart? in App Development https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925335#M12768 <HTML><HEAD></HEAD><BODY><P>Perfect, thanks!</P></BODY></HTML> Wed, 23 Sep 2015 21:38:29 GMT 2015-09-23T21:38:29Z Creating an accumulating count by date in a line chart? https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925333#M12766 <HTML><HEAD></HEAD><BODY><P>I have data from Salesforce, and want to show the growing monthly total for our contacts, i.e. count(name) for the x-axis value Date(MonthStart(CreatedDate)) plus all dates before it. I could only find answers pertaining to sums, but I'm not counting a numerical value. How can I do this?</P><P></P><P>Ex.</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>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CreatedDate</STRONG></TH></TR><TR><TD style="padding: 2px;">209570270</TD><TD style="padding: 2px;">Name1</TD><TD style="padding: 2px;">1/5/15</TD></TR><TR><TD style="padding: 2px;">235920952</TD><TD style="padding: 2px;">Name2</TD><TD style="padding: 2px;"><P>2/5/15</P></TD></TR><TR><TD style="padding: 2px;">252000980</TD><TD style="padding: 2px;">Name3</TD><TD style="padding: 2px;">2/5/15</TD></TR><TR><TD style="padding: 2px;">345989453</TD><TD style="padding: 2px;">Name4</TD><TD style="padding: 2px;">3/5/15</TD></TR><TR><TD style="padding: 2px;">340958092</TD><TD style="padding: 2px;">Name5</TD><TD style="padding: 2px;">5/5/15</TD></TR><TR><TD style="padding: 2px;">235092435</TD><TD style="padding: 2px;">Name6</TD><TD style="padding: 2px;">6/5/15</TD></TR></TBODY></TABLE><P></P><P>Desired Line Chart</P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99846_1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925333#M12766 2021-12-22T15:42:54Z Re: Creating an accumulating count by date in a line chart? https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925334#M12767 <HTML><HEAD></HEAD><BODY><P>Try rangesum(above(count(name),0, rowno()). You'll want to add a dummy record for the missing date too. See attached example.</P></BODY></HTML> Wed, 23 Sep 2015 15:52:17 GMT https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925334#M12767 Gysbert_Wassenaar 2015-09-23T15:52:17Z Re: Creating an accumulating count by date in a line chart? https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925335#M12768 <HTML><HEAD></HEAD><BODY><P>Perfect, thanks!</P></BODY></HTML> Wed, 23 Sep 2015 21:38:29 GMT https://community.qlik.com/t5/App-Development/Creating-an-accumulating-count-by-date-in-a-line-chart/m-p/925335#M12768 2015-09-23T21:38:29Z