Recurrent incremental value in a Qlik Sense Table object (alternatively Straight Table in QlikView)
I'm looking for the fastest way to calculate an ExpectedValue according to the algorithm presented below. IMPORTANT: it must be done on a sheet in the TABLE OBJECT, not in the script as the calculation must work dynamically based on filter selections.
Looks good! I had a similar one but RangeSum enables to avoid 1st row evaluation.
So I have one more question:
I analyze Bundesliga matches looking for win\loss\draw series. The only thing that remain is to display the MAX value from the HowManyInArow column in a KPI. It should be done dynamically as I can filter by either a season or a team. I'm struggling with it as we can't refer to a column name in a specific table.
I have not found a way using AGGR either, as we have recurrent calculation.
is it even possible?
ex-Training Manager at Qlik Central-Eastern Europe