topic Displaying the most commont value in QlikView https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313803#M115835 <HTML><HEAD></HEAD><BODY><P>Mode( <EM>PaymentTermField </EM>)</P><P></P><P>In QlikView the mode function works on text as well as numbers.&nbsp; -Isaiah</P></BODY></HTML> Wed, 31 Aug 2011 12:06:25 GMT isaiah82 2011-08-31T12:06:25Z Displaying the most commont value https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313802#M115834 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Trying to build a top 20 supplier table which displays the full spend average payment lead time and average/mean payment term description.</P><P></P><P>However i can get the average payment terms to work.</P><P></P><P>So how do i get the column to show the most frequent payment term used for that specific vendor?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Wed, 31 Aug 2011 11:29:26 GMT https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313802#M115834 2011-08-31T11:29:26Z Displaying the most commont value https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313803#M115835 <HTML><HEAD></HEAD><BODY><P>Mode( <EM>PaymentTermField </EM>)</P><P></P><P>In QlikView the mode function works on text as well as numbers.&nbsp; -Isaiah</P></BODY></HTML> Wed, 31 Aug 2011 12:06:25 GMT https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313803#M115835 isaiah82 2011-08-31T12:06:25Z Displaying the most commont value https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313804#M115836 <HTML><HEAD></HEAD><BODY><P>Just a comment (don't know if it's an issue in your case):</P><P></P><P>If more than one value is equally commonly occurring, NULL is returned.</P></BODY></HTML> Wed, 31 Aug 2011 13:05:51 GMT https://community.qlik.com/t5/QlikView/Displaying-the-most-commont-value/m-p/313804#M115836 swuehl 2011-08-31T13:05:51Z