Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Mode( PaymentTermField )
In QlikView the mode function works on text as well as numbers. -Isaiah
Mode( PaymentTermField )
In QlikView the mode function works on text as well as numbers. -Isaiah
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.