topic Re: trying to rank a variable and return the string associated with the top ranked variable in QlikView https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819541#M1018820 <HTML><HEAD></HEAD><BODY><P>Thanks for that Piet, it works perfectly!</P></BODY></HTML> Mon, 30 Mar 2015 15:57:25 GMT 2015-03-30T15:57:25Z trying to rank a variable and return the string associated with the top ranked variable https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819539#M1018818 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am having some issues when trying to rank a variable and return the string associated with the top ranked variable! </P><P></P><P>I have created a cross table bringing in the client ID, bank and bank data!&nbsp; Is there a way of ranking/sorting these to allow me to pull the most popular bank name into a text box without having to create a huge IF statement comparing the sum of each bank with all the rest of the banks?(of which there are many)!</P><P></P><P>Does any one have any ideas?</P><P></P><P>Thanks</P><P></P><P>Peter</P></BODY></HTML> Mon, 30 Mar 2015 11:27:51 GMT https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819539#M1018818 2015-03-30T11:27:51Z Re: trying to rank a variable and return the string associated with the top ranked variable https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819540#M1018819 <HTML><HEAD></HEAD><BODY><P>You can use the rank function, something like</P><P></P><P>=Concat(Aggr(if(Rank(Sum(BankData))=1,Bank),Bank),' / ')</P><P></P><P>I've also used Concat, as there can be more then one Bank with the same outcome</P></BODY></HTML> Mon, 30 Mar 2015 15:49:28 GMT https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819540#M1018819 stigchel 2015-03-30T15:49:28Z Re: trying to rank a variable and return the string associated with the top ranked variable https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819541#M1018820 <HTML><HEAD></HEAD><BODY><P>Thanks for that Piet, it works perfectly!</P></BODY></HTML> Mon, 30 Mar 2015 15:57:25 GMT https://community.qlik.com/t5/QlikView/trying-to-rank-a-variable-and-return-the-string-associated-with/m-p/819541#M1018820 2015-03-30T15:57:25Z