Find the model of a column

[Anonymous]

Hello

I am looking to find the value which appears the most in a field

i.e.

1

2

3

1

1

2

Modal would be 1

What Expression would be used to do that

Thank you

[sunny_talwar · Accepted solution]

May be Mode function (Mode Function)

Mode(FieldName)

[BalaBhaskar_Qlik]

The Mode function can be used in the script or in a chart to find the most commonly-occurring value in aggregated data.

So, Mode(Field).