Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
biggusdoggus
Contributor

Combo chart with cumulative

Hi all. Hopefully this is pretty straight forward.

So here is the script I have for my app:

SELECT

True_Churn, Retention_Target, Date_Measure, Closing_Base, Opening_Base,

(Closing_Base - Opening_Base) as Flow

from xxxxx

And here is my data table:

Opening_BaseClosing_BaseTrue_ChurnRetention_TargetDate_Measure
4033540838788.50%01-01-18
408384421954985.90%01-02-18

Each month I'm going to update the table with the previous month's data.

I want to product a combo bar/line graph showing each month's Flow number as the bars, with the cumulative month on month Flow as the line.

The basics are pretty, well, basic:

  • Dimension = month(Date_Measure)
  • First measure for the bars = sum(Flow)

But how do I add a cumulative line graph to it please?

I have tried

if(Sum(if(year(Date_Measure)=2018, Flow,0))>0,  rangesum( above( sum(if(year(Date_Measure) = 2018,Flow,0)),0,rowno())), null)


But it's returning a figure for Feb of 27,188 (no idea how it's got that) not the expected 3,884.

Tags (2)
1 Solution

Accepted Solutions
biggusdoggus
Contributor

Re: Combo chart with cumulative

Hi - sorted. I had made it far too complicated. Just a straight

Rangesum(above(sum(Flow),0,RowNo()))

Has done it.

View solution in original post

3 Replies
YoussefBelloum
Esteemed Contributor

Re: Combo chart with cumulative

Hi,

can you attach some data ? 12 lines with 2 columns: Flow and Date_measure

biggusdoggus
Contributor

Re: Combo chart with cumulative

Hi Youssef

As attached - it's my actual data. Thanks!

biggusdoggus
Contributor

Re: Combo chart with cumulative

Hi - sorted. I had made it far too complicated. Just a straight

Rangesum(above(sum(Flow),0,RowNo()))

Has done it.

View solution in original post