Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Return String based on Highest Count

Try like:

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

2 Replies
MVP
MVP

Re: Return String based on Highest Count

Try like:

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

Not applicable

Re: Return String based on Highest Count

This works!

Thanks a lot for the help

Community Browser