Producing a running total column based on 3 variables.

Dylangkx — Tue, 02 Apr 2024 03:28:03 GMT

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!

topic Producing a running total column based on 3 variables. in App Development

Producing a running total column based on 3 variables.