Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
paweln
Contributor III
Contributor III

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
Specialist III
Specialist III

first 20 based on raking

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

 

ur Mesure :Avg(Value)

Channa