Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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!