Discussion board where members can get started with Qlik Sense.
I'd like to calculate average but only on first 20 values of many values. How can I do that?
first 20 based on raking
ur Dimension : =If(Aggr(Rank(Avg(Value)),DIM)<=20,DIM)
ur Mesure :Avg(Value)