I'm hoping this is a simple one as I'm new to Qlik expressions.
I have a table which (in a very simplified form) has the following data:
Category
Measure
0
50
0
52
0
54
0
50
2
61
2
63
2
61
2
53
I want the calculation to calculate the average of the Measure only for the Max category. So here it would be the average of 61,63,61,53 = 59.5.
Note: This doesn't need to be independent of the selection of the visual or anything, so if the current selection only returns the above rows it shouldn't look at rows outside this selection.
