Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
Not applicable

Running total in combo chart

Hi All,

I'm trying to create a combo chart containing sales by month as a bar chart and a running total of sales as a line graph.

Does anyone know how to create the running total portion? I can only get the line chart to reflect the month by month sales (which is what the bar chart is already doing).

Thanks

1 Solution

Accepted Solutions
Highlighted

Re: Running total in combo chart

Should be like this

RangeSum(Above(Sum(Sales), 0, RowNo()))

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: Running total in combo chart

rangesum(above(your_expression),0,rowNo(Total))

I can walk on water when it freezes
Highlighted

Re: Running total in combo chart

Should be like this

RangeSum(Above(Sum(Sales), 0, RowNo()))

View solution in original post

Highlighted
Not applicable

Re: Running total in combo chart

You mean adding previous dimension expression value or anything else, can you explain in brief.

Highlighted
Not applicable

Re: Running total in combo chart

RangeSum(Above(Sum(Sales), 0, RowNo())

The above calculation worked perfectly. Thank you for the quick response!