Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

Find the model of a column

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Find the model of a column

May be Mode function (Mode Function)

Mode(FieldName)

2 Replies
MVP
MVP

Re: Find the model of a column

May be Mode function (Mode Function)

Mode(FieldName)

balabhaskarqlik
Honored Contributor

Re: Find the model of a column

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).