Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Return String based on Highest Count

Hello,

In a text field I want to display the name of a value with the highest count.

So far I have this

=MaxString(aggr(Count({1<[Billable_Status] = {Billable}>}Practice)Practice))

This returns back the highest count of billable employees in a practice, but I want it to display the name of the practice not the count.

Thanks.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=FirstSortedValue( YourNamefield, - aggr(Count({1<[Billable_Status] = {'Billable'}>}Practice), Practice) )

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

=FirstSortedValue( YourNamefield, - aggr(Count({1<[Billable_Status] = {'Billable'}>}Practice), Practice) )

Not applicable
Author

This works!

Thanks a lot for the help