How to show only the max field value in graph

[isorinrusu]

Hi,

I have a dimension 'Hour', a dimension 'Computer' and for each combination of them a value, 'Cpu Usage'.

Now, if I draw a bar chart with Hour as the dimension and 'max("Cpu Usage")', everything works just fine: I get the max Cpu usage for each hour. The problem is that I want to get the name of the computer that has the max Cpu usage, besides its value.

¿How can I obtain that? I've tried a trillion of different things (ranks, aggrs, firstsortedvalue....) but I can't get it.

In table format, I would like something like:

Hour     Computer     Value

12:00     A               17

13:00     C               23

14:00     C               12

Where the value corresponds to the computer, being the max value.

Can anyone help please?

[Anonymous]

use max({<Hour=>Value)

[swuehl · Accepted solution]

Try an expression like

dual( FirstSortedValue( Computer, -Value) &': '&max(Value) , max(Value) )

[qlikmsg4u]

like this?

[avinashelite]

Simply way is to add one more expression as below:

Max(Value)&'-'&Computer

and uncheck the bar and check on the values on data points

[isorinrusu]

Thank you swuehl‌ and everyone else.

Indeed, your solutions work, although as I was afraid, I asked the wrong question. The problem was a little more complex than this

What I wanted was to put the computer as a dimension and then show only the greatest value, as well as its min value and its average for each hour (and some more dimensions).

What I've finally done is to remove Computer as the dimension, show the max value using the FirstSortedValue, and show the min and max of that same computer using the FirstSortedValue in the Set Analysis.

Thanks!