topic Re: Most repeated value in QlikView

Most repeated value

Fri, 04 Nov 2016 12:21:59 GMT

Hi all,

i have to obtain the most repeated value in a field. For example :

LOAD * INLINE [

Value

];

The most repeated value is 4. Anyone know how to do it?

Thanks in advanced

sunny_talwar — Fri, 04 Nov 2016 12:27:29 GMT

Try with Mode function may be

Mode(Value)

sunny_talwar — Fri, 04 Nov 2016 12:27:53 GMT

Check for a script based example here:

cspencer3 — Fri, 04 Nov 2016 12:31:41 GMT

Mode() should do the trick!

Fri, 04 Nov 2016 12:33:45 GMT

Great!! thanks Sunny, i lost many time trying with the funcion "for" and "if"