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: 
Not applicable

Expression that leads to most occuring value

Hi everyone,

I am working on a study project to build a management dashboard for a school project.
I am far ahead of my classmates, because i find this very interesting to work on.

I am having some issues I can't solve myself. I have searched for common questions and i see them asked frequently but non of the solutions seem to solve my 'problem'.

I have a very small dataset to work with.


I have a table that looks like this:


Name | Frequency

A               34

B               21

C               19

D

.

.

I need to show in a single text field what the most occuring Name is, in this case 'Name A'.
How do I manage to do so?

I am very sory for my noob-isch question on this case, unfortunatly I cant figure out how to do this.

Best regards

Joerie
Student Business Intelligence

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a Text Object and write below

=FirstSortedValue(Name, -Frequency)

Update : If Frequency is coming as an aggregation of some field... i.e. Count(Name) you can use as below...

=FirstSortedValue(Name, Aggr(-Count(Name),Name))

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Create a Text Object and write below

=FirstSortedValue(Name, -Frequency)

Update : If Frequency is coming as an aggregation of some field... i.e. Count(Name) you can use as below...

=FirstSortedValue(Name, Aggr(-Count(Name),Name))

Not applicable
Author

Thanks!


That simple!

MK_QSL
MVP
MVP

Please close the thread by selecting appropriate answer.