Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

1 Solution

Accepted Solutions

Re: Creating an accumulating count by date in a line chart?

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
2 Replies

Re: Creating an accumulating count by date in a line chart?

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

Re: Creating an accumulating count by date in a line chart?

Perfect, thanks!

Community Browser