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: 
pschwegler003
Contributor II
Contributor II

How to return most common Stringvalue

Hi all,

I would like to make a chartfunction which returns the stringvalue of the most common stringvalue in data.

I have a column in data containing the following fields (distinct):

BE (8 times)

DE (5 times)

So I wish return stringvalue:  "BE" which I would like to use further as a variable.

When above is not clear enough, let me know.

Thanks in advance!

Pascal

1 Reply
sunny_talwar

May be this

FirstSortedValue(StringValue, -Aggr(Count(StringValue), StringValue))