Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top 10 sales in set analysis

How may i get top 10 sales in set analysis, anyone can u briefly explain it?

12 Replies
Anil_Babu_Samineni

If your answer is solved please close this thread with correct answer

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prasadmundewadi
Contributor III
Contributor III

I have already a complex set analysis and then on top of it want to add the top 10 condition.

e.g. Need to get the sum

Opportunity with the Top 10 Values with below conditions:

1) Status <> Omitted

2) Current Qtr Flag = Y

3) Won flag = Y

Sum({<[Status]-={'Omitted'}, [Current Qtr Flag]={'Y'}, [Won Flag]={'Y'}>} Value)

Now where do i add the Rank in the above set analysis?

sjaiswal13
Contributor II
Contributor II

Hi Prasadmundewadi,

Did the rank with all the conditions combination work for you?

 

Thanks,

Sonam