Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating an accumulating count by date in a line chart?

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?

Ex.

IDNameCreatedDate
209570270Name11/5/15
235920952Name2

2/5/15

252000980Name32/5/15
345989453Name43/5/15
340958092Name55/5/15
235092435Name66/5/15

Desired Line Chart

1.PNG

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try rangesum(above(count(name),0, rowno()). You'll want to add a dummy record for the missing date too. See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try rangesum(above(count(name),0, rowno()). You'll want to add a dummy record for the missing date too. See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Perfect, thanks!