Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avarage from Top 5

Hi all,

how can i calculate the avarage from Top 4 positions.

F1Rank
11
52
123
144
515
416

(1+5+12+14)/4

I trying this:

if(aggr(rank(count(F1)),orderID)<=4,sum(distinct F1)/count(distinct F1))

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

For all who are interested, here is the solution:

sum(distinct {<F1={$(=concat(if(aggr(rank( count (F1)),F1)<=5, F1), ', '))}>}

Until next time Wink

View solution in original post

4 Replies
Not applicable
Author

Hi Eugen,

I think you should include the rank also in your calculations. This way it will calculate based on your selection.

Not applicable
Author

HI, sorry, i don't now what you mean.

How can I expect with the top 5. I want to calculate the sum of top 5

Thanks

johnw
MVP
MVP

avg(if(Rank<5,F1))

At least for the sample table you posted. It looks like your real data is more complicated, since it mentions an OrderID that isn't in your sample. But you don't show your real data, and first you said you wanted the average of the top four and now you say you want the sum of the top five, so so I can't actually solve the problem, since you haven't given me the real problem to solve.

Not applicable
Author

For all who are interested, here is the solution:

sum(distinct {<F1={$(=concat(if(aggr(rank( count (F1)),F1)<=5, F1), ', '))}>}

Until next time Wink

View solution in original post