Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

automated text in KPI for the top customer

FirstSortedValue(([customer Name]), ( Count(sales date), Rank([Customer Name]),1))) this does not work in KPI , to get the top 1 customer .

2 Replies
Clever_Anjos
Support
Support

Try with: 

FirstSortedValue([customer Name],aggr(-Count(sales date),[customer Name]))

Qlikuser09
Creator II
Creator II
Author

thanks, I was able to get the top 3 products, but I wanted to get the top 3 customers for those top products.