topic Re: How to get variable after count? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006641#M645362 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>It shows the country who ranks first in sum(Sales)</P><P></P><P></P><P>concat( distinct if( aggr(rank( total sum(Sales)) , countries_world.Name )=1, countries_world.Name))</P></BODY></HTML> Mon, 30 Nov 2015 16:55:53 GMT JonnyPoole 2015-11-30T16:55:53Z How to get variable after count? https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006639#M645360 <HTML><HEAD></HEAD><BODY><P>How do I replace the number after counting with the name of the Airline?</P><P></P><P><IMG alt="airline-kpi.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107609_airline-kpi.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 30 Nov 2015 10:51:13 GMT https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006639#M645360 2015-11-30T10:51:13Z Re: How to get variable after count? https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006640#M645361 <HTML><HEAD></HEAD><BODY><P>Replace the number? Not sure what you mean</P></BODY></HTML> Mon, 30 Nov 2015 16:34:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006640#M645361 sunny_talwar 2015-11-30T16:34:23Z Re: How to get variable after count? https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006641#M645362 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>It shows the country who ranks first in sum(Sales)</P><P></P><P></P><P>concat( distinct if( aggr(rank( total sum(Sales)) , countries_world.Name )=1, countries_world.Name))</P></BODY></HTML> Mon, 30 Nov 2015 16:55:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006641#M645362 JonnyPoole 2015-11-30T16:55:53Z Re: How to get variable after count? https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006642#M645363 <HTML><HEAD></HEAD><BODY><P>or this...</P><P></P><P>concat( distinct {&lt;countries_world.Name={"=aggr(rank( total sum(Sales)), countries_world.Name )=1"}&gt;}&nbsp; countries_world.Name)</P></BODY></HTML> Mon, 30 Nov 2015 17:03:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-variable-after-count/m-p/1006642#M645363 JonnyPoole 2015-11-30T17:03:16Z