Producing a running total column based on 3 variables.

[Dylangkx]

Hi,
Im very new to Qliksense (1 week in) and have been working with Tableau for the past 2 years. Can someone help me with this issue. 

I am required to produce a running total column, that is taking to account 3 values: Event, Country and Date.
e.g. To have a running total for Event 1, at Country A and for the period of the dates available, within a table of multiple events, countries and dates.

However, I'm facing an issue where my formula below produces random values instead of getting an accurate running average:

rangesum (above(Sum({<EVENT_ID,DATE,COUNTRY >} [ValueToCount]),0, rowno()))

Column 1 Represents EVENT_ID, Column 2 Represents DATE, Column 3 Represents COUNTRY and Column 4 represents ValueToCount.

Column 5 will be the output.

Do advice on how I am able to remedy this issue!