Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Employee
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
Employee
Employee

or this...

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