Top 10 Claims . ?

[suvechha_b]

Hi All ,

Please kindly assist me to get top 10 claims for Max or date selection Day and also for Month. sample model attached .

[dplr-rn]

I would create a master calendar on the date field and use something like below expressions
Top 10 for month = Sum({<[Claim Registered]=,Month={"$(=Month(Max([Claim Registered])))"}>}Gross)
Top 10 for Day = Sum({<[Claim Registered]={"$(=Date(Max([Claim Registered]),'YYYY-MM-DD'))"}>}Gross)

[Channa]

=If(Aggr(Rank(Sum(Gross)),Broker)<=10,Broker)

it will bring to 10 brokers by Gross

[suvechha_b]

Please help me to create master calendar on the date field - [Claim Registered] and create a [Month] field.

[dplr-rn]

Check below link

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/