Discussion Board for collaboration related to Creating Analytics for QlikView.
I have dimension and multiple dates with measure corresponding to them.
Need to calculate average in straight table . But should consider only latest measure based on date. Sample data and expected output given below.
Hi, this result can be done in a table with Application_Name and Date as dimension and this expression:
Avg(Aggr(If(Date=Max(TOTAL<Application_Name> Date), Measure), Application_Name, Date))
Maybe you need to uncheck 'supress zero values' and use a calculated dimension to keep only the rows you want:
=Aggr(If(Date=Max(TOTAL<Application_Name> Date), Date), Application_Name, Date)