Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Trouble with mode function

Hello,

I have a problem with mode function (moda (minutos)) in order to find the most occurring value displayed in a KPI.

Captura de pantalla 2015-12-16 a las 1.04.00 p.m..png

The problem is when different values are occurring the same amount of times, then null is retrieved.

What alternatives i have to fix the problem?

King Regards

Gerd Neumann

2 Replies
reddys310
Honored Contributor II

Re: Trouble with mode function

Hi Gerd,

Thats the limitation of the MODE function. When the occurrence of two values is the same a NULL is returned.

Try this function instead:

max(aggr(count(<Field>),<Field>))

Not applicable

Re: Trouble with mode function

Hello Sangram,

I tried this and still not working

Captura de pantalla 2015-12-17 a las 2.53.56 p.m..png

Captura de pantalla 2015-12-17 a las 2.54.13 p.m..png

Regards,

Gerd Neumann