How to get most common stringvalue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic How to get most common stringvalue in QlikView