Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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