Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
1 Solution

Accepted Solutions

Re: Expression that leads to most occuring value

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

3 Replies

Re: Expression that leads to most occuring value

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

Re: Expression that leads to most occuring value

Thanks!


That simple!

Re: Expression that leads to most occuring value

Please close the thread by selecting appropriate answer.

Community Browser