How to see only the Top Sellers Based on Rating on table

[Anonymous]

I need some help , I am trying to create a table in which I am trying to show the highest seller symbol based on risk.

When I load this into qlikview , I see all but I want to see highest distinct level based on Risk. So for AA I just want to see Very High, for CC I just want to see High.

I would also like to be able to alternate between the two in a separate view, can someone please help, thousand thanks

Seller Symbol	Risk	Level
AA	High	3
AA	Low	1
AA	Very High	4
BB	Medium	2
CC	Medium	3
CC	High	3
DD	Low	1
DD	High	3
EE	Medium	2
FF	High	3
GG	High	3
GG	Medium	2

[Anonymous]

Thank you everyone for answering this question, for some reason even after fixing the typo there ,   I am not getting the right results , When I put that formula it does 90% of the work but it is skipping some symbols that might have three risk levels.   I am not sure what to do here. 

[Anonymous]

it is also skipping some symbols all together as well. the actual sheet instead of symbols has company names written out and I am trying to find high level separated by sectors

[tamilarasu]

Mike - Could you attach a sample file that demonstrates this issue.?

[luismadriz]

Hi Mike,

I'd recommend you close this post marking the appropriate answers Helpful and Correct, then open another post where you share the data and some screenshots of the problem and expected outcome where you use the solution Mariusz provided: FirstSortedValue(Risk,-Level)

Cheers,

Luis

[Anonymous]

Everyone is correct, am halfway there. The calculation works to an extent. I will follow what you said Luis

[Anonymous]

Thank you Qlikview Community

[Anonymous]

https://community.qlik.com/message/1402849#1402849 second q

[Anonymous]

https://community.qlik.com/message/1402849#1402849 second q