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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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.