Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thorsten_edler
Contributor II
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
swuehl
MVP
MVP

Try

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

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

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

thorsten_edler
Contributor II
Contributor II
Author

Great !

Thank you very much.

Thorsten