Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (3)
3 Replies

Re: How to get variable after count?

Replace the number? Not sure what you mean

Employee
Employee

Re: How to get variable after count?

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))

Employee
Employee

Re: How to get variable after count?

or this...

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

Community Browser