Displaying the most commont value

[#1]

Hi all,

Trying to build a top 20 supplier table which displays the full spend average payment lead time and average/mean payment term description.

However i can get the average payment terms to work.

So how do i get the column to show the most frequent payment term used for that specific vendor?

Thanks for your help.

[isaiah82 · Accepted solution]

Mode( PaymentTermField )

In QlikView the mode function works on text as well as numbers.  -Isaiah

[swuehl]

Just a comment (don't know if it's an issue in your case):

If more than one value is equally commonly occurring, NULL is returned.