Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Employee
Employee

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.