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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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)