# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Creator III

## TOP 5 Claims

Hi All ,

How can I get the TOP 5 Claims Number who got maximum sum(GROSS_CLAIMS_PAID) with the record_source name .

If you see the sample model attached , the field names are there.

I am not getting how to show the values with record_source_name and with highest 5 claims number who got maximum claims paid .

6 Replies
MVP

You should add the CLAIM_NUMBER dimension and put the dimension limit to the CLAIM_NUMBER not the RECORD_SOURCE_NAME.

Creator III
Author

Hi ,

Please kindly see the sample model attached. Though I have restricted to show 5 still the table is giving value  more that 5.

Specialist III

=If(Aggr(Rank(Sum(GROSS_CLAIMS_PAID)),CLAIM_NUMBER)<=5,CLAIM_NUMBER)

this will bring top 5 clime numbers

it is ur dimension

sum(GROSS_CLAIMS_PAID) as ur measure

Channa
Specialist III

one claim has multiple partners you need to think which one you want to show

if you want to show top 5 after adding partner you need to change expression

Channa
Creator III
Author

Hi Chana ,

I got two dimension

1.Partner - As you mentioned - =if(aggr(rank((Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING))),RECORD_SOURCE_NAME )<=5,RECORD_SOURCE_NAME)

2.Claim Number - As you mentioned - =if(aggr(rank((Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING))),CLAIM_NUMBER )<=5,CLAIM_NUMBER)

Expression is -  Sum(GROSS_CLAIMS_PAID)+Sum(GROSS_CLAIM_OUTSTANDING)

But still not getting top 5 claims . getting result like this -

But when selecting a particular month , it is giving me top 5 claims correct. What can be the problem. My model is huge.thus can't post. But Sample model is not showing the problem.

Specialist III

i dont find this measure in qvf

GROSS_CLAIM_OUTSTANDING

Channa
Tags
Community Browser