Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Please kindly assist me to get top 10 claims for Max or date selection Day and also for Month. sample model attached .
=If(Aggr(Rank(Sum(Gross)),Broker)<=10,Broker)
it will bring to 10 brokers by Gross
Please help me to create master calendar on the date field - [Claim Registered] and create a [Month] field.
Check below link
https://qlikviewcookbook.com/2015/05/better-calendar-scripts/