TOP 5 Claims

[suvechha_b]

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 .

[Vegar]

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

[suvechha_b]

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]

=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]

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

[suvechha_b]

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 -

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]

i dont find this measure in qvf

GROSS_CLAIM_OUTSTANDING