Running Sum across columns

[this]

Hi Qlikkers, I am new to Qlik and try to do something I did in Tableau.
In Tableau this would be a Running Sum(sum(points)) and then tell what direction or dimension to address and partition by. 

I have figured out to use something like this: RangeSum(Above(sum(points),0,ColumnNo())) 
However, this does not work at all. I get an empty sheet.

Is there a good resource to learn all about running calculations?

Kind regards,
Matthias

[marcus_sommer]

Try it with: RangeSum(Above(sum(points),0,RowNo())) 

[this]

Many thanks for the fast reply. I thought the Tableau Community forum has a fast response time. Well, I thought 😉

I have tried that as well. 

This is what I get then: 

Maybe there is something breaking it or I would have to dedicate it to the surname.

[marcus_sommer]

It looked that there isn't a single dimension within the chart else two ones. Therefore try it with:

RangeSum(Above(sum(points),0,RowNo(total))) 

[this]

Hi Marcus

Thank you. 
This gives me the exact same result, unfortunately. 

Could it be due to the data model? Surname is from the drivers table,  round is from the races table, and points are from the result table. The common fields are DriverID and RaceID. I am not sure if I did the correct associative relation. 

Matthias

[marcus_sommer]

I think I would duplicate the chart and changing the type to a table-chart and playing there with the rangesum() and the normal sum(points) and rowno() with and without the total as extra expressions to look if they return the expected results. If you find a working way you could adapt this approach to the line-chart.

[this · Accepted solution]

Hi Marcus

Yes, sorry for the late reply. I could export it as a qvf and send it to a colleague. 

The answer to make it work was to use aggr:
Aggr(RangeSum(Above(Total sum(points),0,RowNo())),surname,round)

Your forumla worked until I took the surname or the constuctor name into detail to split the line.
The syntax is a bit different from what I am used from Tableau.

Next time with next question, I'll upload the qvf with the data if it is shareable to the thread.

Many thanks for your help, I really appreciate it.