YTD and FY as KPI in a table that contains the month as dimension
Hi All,
we have a case, where we try to show the following in a Qlik Sense Table and we hit a wall. Client wants to see for each period the KPI Score (easy part), then the same for all months before the given one and then one for the entire year. Is that one possible at all without having to go to a rolling period AS OF calendar?
Set analysis cannot be used, as it is calculated once for the entire object, I could not make rangeavg() work due to the period being a dimension. Above() would not work, as client wants to select a random set of months only (e.g. they want to select April and June only and on 2 rows to see April, April YTD and April Full Year and on the next one June, June YTD and the same Full Year number.
