Skip to main content

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 
Search instead for 
Did you mean: 
suvechha_b
Creator III
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 .

Please kindly assist me.

Thanks in advance .

6 Replies
Vegar
MVP
MVP

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

image.png

image.png

suvechha_b
Creator III
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.

Please kindly see the attachment.

Channa
Specialist III
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
Channa
Specialist III
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
suvechha_b
Creator III
Creator III
Author

Hi Chana ,

A claim Cannot have multiple Partners. - To answer your question

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 -

 

result.PNG

 

 

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.

Channa
Specialist III
Specialist III

i dont find this measure in qvf

 

GROSS_CLAIM_OUTSTANDING

Channa