Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suvechha_b
Contributor III

Top 5 claims across for the claim_registered across all brokers ?

Hi All,

How to get top 5 claims across for the claim_registered across all brokers in the sample model attached.

Please check Brokers Report and Top 5 Claims by Value.

clipboard_image_0.png

 

 

Thanks,

Tags (1)
2 Replies
sagarjagga
Contributor

Re: Top 5 claims across for the claim_registered across all brokers ?

may be you can try below expression .
if(aggr(rank(sum(Gross)),Broker)<=5,ClaiimNumber)
suvechha_b
Contributor III

Re: Top 5 claims across for the claim_registered across all brokers ?

Hi,

I used you expression - but still not working. I got 7 claims and I did top 10 but it is not showing all the seven. please kindly assist . model attached.

clipboard_image_0.png