Qlik Community

Qlik Sense App Development

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

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.

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.

Community Browser