Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
paweln
New Contributor II

Calculation only on first 20 values

Hi guys,

I'd like to calculate average but only on first 20 values of many values. How can I do that?

1 Reply
Channa
Valued Contributor III

Re: Calculation only on first 20 values

first 20 based on raking

ur Dimension : =If(Aggr(Rank(Avg(Value)),DIM)<=20,DIM)

 

ur Mesure :Avg(Value)

Channa