Least frequent value in list.

[thorsten_edler]

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

[swuehl · Accepted solution]

Try

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

[thorsten_edler]

Great !

Thank you very much.

Thorsten