topic FUNCTION RETURN VALUE THAT IS MORE REPEAT in QlikView

topic FUNCTION RETURN VALUE THAT IS MORE REPEAT in QlikView https://community.qlik.com/t5/QlikView/FUNCTION-RETURN-VALUE-THAT-IS-MORE-REPEAT/m-p/378904#M141338 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">I NEED</SPAN> <SPAN class="hps">AN</SPAN> <SPAN class="hps">EXPRESSION</SPAN> <SPAN class="hps">OR</SPAN> <SPAN class="hps">FUNCTION</SPAN> <SPAN class="hps">TO</SPAN> <SPAN class="hps">RETURN THE</SPAN> <SPAN class="hps">VALUE</SPAN> <SPAN class="hps">THAT</SPAN> <SPAN class="hps">MORE</SPAN> <SPAN class="hps">REPEATS</SPAN> <SPAN class="hps">WITHIN</SPAN> <SPAN class="hps">A FIELD</SPAN></P><P> <SPAN class="hps">EX</SPAN>: <SPAN class="hps">VALUE</SPAN></P><P>           <SPAN class="hps">a</SPAN></P><P>           <SPAN class="hps">2</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>           <SPAN class="hps">4</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>  <SPAN class="hps">The</SPAN> <SPAN class="hps">EXPRESSION</SPAN></P><P> <SPAN class="hps">SUM</SPAN> <SPAN class="hps atn">(</SPAN>VALUE)</P><P> <SPAN class="hps">SHOULD</SPAN> <SPAN class="hps">RETURN</SPAN> <SPAN class="hps">3</SPAN></P><P></P><P> <SPAN class="hps">THANK YOU</SPAN></P></BODY></HTML> Fri, 17 Aug 2012 17:27:07 GMT rogeriobarbosa 2012-08-17T17:27:07Z FUNCTION RETURN VALUE THAT IS MORE REPEAT https://community.qlik.com/t5/QlikView/FUNCTION-RETURN-VALUE-THAT-IS-MORE-REPEAT/m-p/378904#M141338 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">I NEED</SPAN> <SPAN class="hps">AN</SPAN> <SPAN class="hps">EXPRESSION</SPAN> <SPAN class="hps">OR</SPAN> <SPAN class="hps">FUNCTION</SPAN> <SPAN class="hps">TO</SPAN> <SPAN class="hps">RETURN THE</SPAN> <SPAN class="hps">VALUE</SPAN> <SPAN class="hps">THAT</SPAN> <SPAN class="hps">MORE</SPAN> <SPAN class="hps">REPEATS</SPAN> <SPAN class="hps">WITHIN</SPAN> <SPAN class="hps">A FIELD</SPAN></P><P> <SPAN class="hps">EX</SPAN>: <SPAN class="hps">VALUE</SPAN></P><P>           <SPAN class="hps">a</SPAN></P><P>           <SPAN class="hps">2</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>           <SPAN class="hps">4</SPAN></P><P>           <SPAN class="hps">3</SPAN></P><P>  <SPAN class="hps">The</SPAN> <SPAN class="hps">EXPRESSION</SPAN></P><P> <SPAN class="hps">SUM</SPAN> <SPAN class="hps atn">(</SPAN>VALUE)</P><P> <SPAN class="hps">SHOULD</SPAN> <SPAN class="hps">RETURN</SPAN> <SPAN class="hps">3</SPAN></P><P></P><P> <SPAN class="hps">THANK YOU</SPAN></P></BODY></HTML> Fri, 17 Aug 2012 17:27:07 GMT https://community.qlik.com/t5/QlikView/FUNCTION-RETURN-VALUE-THAT-IS-MORE-REPEAT/m-p/378904#M141338 rogeriobarbosa 2012-08-17T17:27:07Z Re: FUNCTION RETURN VALUE THAT IS MORE REPEAT https://community.qlik.com/t5/QlikView/FUNCTION-RETURN-VALUE-THAT-IS-MORE-REPEAT/m-p/378905#M141339 <HTML><HEAD></HEAD><BODY><P>The mode function gives the value that shows up the most in a data set.</P><P></P><P>=mode(VALUE)</P></BODY></HTML> Fri, 17 Aug 2012 17:42:36 GMT https://community.qlik.com/t5/QlikView/FUNCTION-RETURN-VALUE-THAT-IS-MORE-REPEAT/m-p/378905#M141339 Nicole-Smith 2012-08-17T17:42:36Z