Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cspindley
Contributor III
Contributor III

coding challenge

i have a chart expression:

[TFC Specialty Name Referred To] where count(distinct [Service ReferralID])=max(aggr(count(distinct [Service ReferralID]),[TFC Specialty Name Referred To]))

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)

the team i am  in are looking into this but are struggling, any help would be much app reciated !

1 Reply
sunny_talwar

May be this

FirstSortedValue([TREATMENT FUNCTION], -Aggr(Count(DISTINCT [Service ReferralID]), [TFC Specialty Name Referred To]))