topic Re: How to return most common Stringvalue in QlikView https://community.qlik.com/t5/QlikView/How-to-return-most-common-Stringvalue/m-p/1381096#M806607 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(StringValue, -Aggr(Count(StringValue), StringValue))</STRONG></P></BODY></HTML> Mon, 30 Oct 2017 23:20:32 GMT sunny_talwar 2017-10-30T23:20:32Z How to return most common Stringvalue https://community.qlik.com/t5/QlikView/How-to-return-most-common-Stringvalue/m-p/1381095#M806606 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to make a chartfunction which returns the stringvalue of the most common stringvalue in data.</P><P>I have a column in data containing the following fields (distinct):</P><P>BE (8 times)</P><P>DE (5 times)</P><P></P><P>So I wish return stringvalue:&nbsp; "BE" which I would like to use further as a variable.</P><P></P><P>When above is not clear enough, let me know.</P><P></P><P>Thanks in advance!</P><P></P><P>Pascal </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-return-most-common-Stringvalue/m-p/1381095#M806606 pschwegler003 2020-11-25T16:16:04Z Re: How to return most common Stringvalue https://community.qlik.com/t5/QlikView/How-to-return-most-common-Stringvalue/m-p/1381096#M806607 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(StringValue, -Aggr(Count(StringValue), StringValue))</STRONG></P></BODY></HTML> Mon, 30 Oct 2017 23:20:32 GMT https://community.qlik.com/t5/QlikView/How-to-return-most-common-Stringvalue/m-p/1381096#M806607 sunny_talwar 2017-10-30T23:20:32Z