# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Line Chart: running total with multiple dimensions (month, year)

Dimension1: Month

Dimension2: Year

Measure: Eur_commission (amount)

I can calculate running total with 1 dimension only (month) using the formula:

Rangesum( Above(Sum(eur_commission), 0, RowNo()))

If I add the second dimension (Year), the top chart (no running total) is perfect, the bottom chart (running total)

doesn't work anymore.

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

This?

Expression (which needs actual fields created in the script)

Aggr(RangeSum(Above(Sum(eur_commission), 0, RowNo())), [reg_date.autoCalendar.Year], [reg_date.autoCalendar.Month])

26 Replies
MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

Give this a shot:

Aggr(Rangesum( Above(Sum(eur_commission), 0, RowNo())), Year, Month)

or this

Aggr(Rangesum( Above(Sum(eur_commission), 0, RowNo())), Year, (Month, (Numeric, Ascending)))

New Contributor III

## Re: Line Chart: running total with multiple dimensions (month, year)

Thanks SunnyT,

In facts, I studied your previous replies to other similar questions and I was expecting your reply.

I tried both solutions and I can't make them working.

I attached a test app if you would like to crack it!

Thanks

MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

This?

Expression (which needs actual fields created in the script)

Aggr(RangeSum(Above(Sum(eur_commission), 0, RowNo())), [reg_date.autoCalendar.Year], [reg_date.autoCalendar.Month])

New Contributor III

## Re: Line Chart: running total with multiple dimensions (month, year)

This is a very enlightening reply and is fixing many of my issue of newbie.

In facts, I widely use the defined Dimensions  (as shortcut and as easy interface with the lingo of the column names) and probably for this reason many scripts I'm using are failing.

Thank you very much.

MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

I am glad I was able to offer help.

Best,

Sunny

Not applicable

## Re: Line Chart: running total with multiple dimensions (month, year)

Hi,

I am also struggling with similar issue in qlikview. Could you please send me qlikview file as I am not able to open .qvf file.

When I tried using same formula as mentioned in other replies, it is giving very weird results.

Aggr(RangeSum(Above(Sum(eur_commission), 0, RowNo())), [reg_date.autoCalendar.Year], [reg_date.autoCalendar.Month])

MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

Which version of QlikView are you using?

Not applicable

## Re: Line Chart: running total with multiple dimensions (month, year)

I am using Qlikview  12

MVP

## Re: Line Chart: running total with multiple dimensions (month, year)

QV12 is good....Would you be able to share your expression that you used and images of what you have?