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!