topic Re: Text object properties - max number and name in QlikView https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772887#M1019907 <HTML><HEAD></HEAD><BODY><P>Hi Stephen, can you post an example of the data and which results are you expecting?</P><P></P><P>A simple text explanation will be enough</P></BODY></HTML> Mon, 23 Mar 2015 16:40:58 GMT rubenmarin 2015-03-23T16:40:58Z Text object properties - max number and name https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772886#M1019906 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>What formula / expression do I use to make my text object show the max number and the equivalent subject / name?</P><P></P><P>Many thanks.</P></BODY></HTML> Mon, 23 Mar 2015 16:30:56 GMT https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772886#M1019906 knightwriter 2015-03-23T16:30:56Z Re: Text object properties - max number and name https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772887#M1019907 <HTML><HEAD></HEAD><BODY><P>Hi Stephen, can you post an example of the data and which results are you expecting?</P><P></P><P>A simple text explanation will be enough</P></BODY></HTML> Mon, 23 Mar 2015 16:40:58 GMT https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772887#M1019907 rubenmarin 2015-03-23T16:40:58Z Re: Text object properties - max number and name https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772888#M1019908 <HTML><HEAD></HEAD><BODY><P>Hi Ruben,</P><P></P><P>So I have quite a lot of activities and I want the text object to show the sum of the highest activity, along with the activity name only.</P><P></P><P>Does this explain?</P></BODY></HTML> Mon, 23 Mar 2015 16:51:52 GMT https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772888#M1019908 knightwriter 2015-03-23T16:51:52Z Re: Text object properties - max number and name https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772889#M1019909 <HTML><HEAD></HEAD><BODY><P>It can be something like:</P><P>=Aggr(If(Rank(Count(ActivityName))=1, ActivityName &amp; ': ' &amp; Count(ActivityName)), ActivityName)</P></BODY></HTML> Mon, 23 Mar 2015 16:58:09 GMT https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772889#M1019909 rubenmarin 2015-03-23T16:58:09Z Re: Text object properties - max number and name https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772890#M1019910 <HTML><HEAD></HEAD><BODY><P>Beautiful! Just beautiful</P></BODY></HTML> Mon, 23 Mar 2015 17:09:02 GMT https://community.qlik.com/t5/QlikView/Text-object-properties-max-number-and-name/m-p/772890#M1019910 knightwriter 2015-03-23T17:09:02Z