Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

thorsten_edler
New Contributor II

Least frequent value in list.

Hello.

Is there a function in Qlikview that gives the minimum number of occurences of a value, kind of the opposite of mode() ?

The term 'max(Count(VALUE))' throws an 'Error in expression'.

regards

Thorsten Edler

1 Solution

Accepted Solutions
MVP
MVP

Re: Least frequent value in list.

Try

FirstSortedValue(VALUE, aggr(count(VALUE),VALUE))

2 Replies
MVP
MVP

Re: Least frequent value in list.

Try

FirstSortedValue(VALUE, aggr(count(VALUE),VALUE))

thorsten_edler
New Contributor II

Re: Least frequent value in list.

Great !

Thank you very much.

Thorsten

Community Browser