Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get 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

ps I asked this question yesterday with another account, but that e-mailadres was not ok, so hereby again.

0 Replies