Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Re: Running total in combo chart

Should be like this

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

4 Replies
ali_hijazi
Honored Contributor

Re: Running total in combo chart

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

I can walk on water when it freezes

Re: Running total in combo chart

Should be like this

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

Not applicable

Re: Running total in combo chart

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

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!

Community Browser