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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get variable after count?

How do I replace the number after counting with the name of the Airline?

airline-kpi.JPG

3 Replies
sunny_talwar

Replace the number? Not sure what you mean

JonnyPoole
Former Employee
Former Employee

Something like this:

It shows the country who ranks first in sum(Sales)

concat( distinct if( aggr(rank( total sum(Sales)) , countries_world.Name )=1, countries_world.Name))

JonnyPoole
Former Employee
Former Employee

or this...

concat( distinct {<countries_world.Name={"=aggr(rank( total sum(Sales)), countries_world.Name )=1"}>}  countries_world.Name)