https://community.qlik.com/t5/QlikView/coding-challenge/m-p/1614772#M596515 <P>i have a chart expression:</P><P><SPAN>[TFC Specialty Name Referred To] where count(distinct [Service ReferralID])=max(aggr(count(distinct [Service ReferralID]),[TFC Specialty Name Referred To]))</SPAN></P><P><SPAN>that gives me a number, say 999, but what i really what is the name of the TREATMENT FUNCTION, please engage and if you need more detail then call me on 07931 735736 (PERSONal mobile)</SPAN></P><P><SPAN>the team i am&nbsp; in are looking into this but are struggling, any help would be much app reciated !</SPAN></P> Sat, 16 Nov 2024 20:13:36 GMT cspindley 2024-11-16T20:13:36Z https://community.qlik.com/t5/QlikView/coding-challenge/m-p/1614772#M596515 <P>i have a chart expression:</P><P><SPAN>[TFC Specialty Name Referred To] where count(distinct [Service ReferralID])=max(aggr(count(distinct [Service ReferralID]),[TFC Specialty Name Referred To]))</SPAN></P><P><SPAN>that gives me a number, say 999, but what i really what is the name of the TREATMENT FUNCTION, please engage and if you need more detail then call me on 07931 735736 (PERSONal mobile)</SPAN></P><P><SPAN>the team i am&nbsp; in are looking into this but are struggling, any help would be much app reciated !</SPAN></P> Sat, 16 Nov 2024 20:13:36 GMT https://community.qlik.com/t5/QlikView/coding-challenge/m-p/1614772#M596515 cspindley 2024-11-16T20:13:36Z https://community.qlik.com/t5/QlikView/coding-challenge/m-p/1614780#M596516 <P>May be this</P><LI-CODE lang="markup">FirstSortedValue([TREATMENT FUNCTION], -Aggr(Count(DISTINCT [Service ReferralID]), [TFC Specialty Name Referred To]))</LI-CODE> Wed, 21 Aug 2019 12:11:13 GMT https://community.qlik.com/t5/QlikView/coding-challenge/m-p/1614780#M596516 sunny_talwar 2019-08-21T12:11:13Z