Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vicio
Contributor III
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()))

Screen Shot 2017-01-05 at 13.50.14.png

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

doesn't work anymore.

Screen Shot 2017-01-05 at 13.50.50.png

1 Solution

Accepted Solutions
sunny_talwar

This?

Capture.PNG

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])

View solution in original post

28 Replies
sunny_talwar

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)))

vicio
Contributor III
Contributor III
Author

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

sunny_talwar

This?

Capture.PNG

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])

vicio
Contributor III
Contributor III
Author

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.

sunny_talwar

I am glad I was able to offer help.

Best,

Sunny

Not applicable

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])

sunny_talwar

Which version of QlikView are you using?

Not applicable

I am using Qlikview  12

sunny_talwar

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