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 10 Claims . ?

Hi All ,

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

clipboard_image_0.png

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Specialist III
Specialist III

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

 

it will bring to 10 brokers by Gross

Channa
suvechha_b
Creator III
Creator III
Author

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

dplr-rn
Partner - Master III
Partner - Master III