topic Re: Expression that leads to most occuring value in QlikView

Expression that leads to most occuring value

Thu, 17 Apr 2014 13:17:39 GMT

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

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

Re: Expression that leads to most occuring value

MK_QSL — Thu, 17 Apr 2014 13:28:55 GMT

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

Re: Expression that leads to most occuring value

Thu, 17 Apr 2014 13:39:25 GMT

Thanks!

That simple!

Re: Expression that leads to most occuring value

MK_QSL — Thu, 17 Apr 2014 13:39:57 GMT

Please close the thread by selecting appropriate answer.