Aggr or max ?

[tomovangel]

Hello guys, I am relatively new to Qlik Sense, and I have been struggling this past few hours with the following problem:

I have a table from Qlik Connectors which gives me sub_name( hour of the day) and value( number of online fans( from my FB page))
I want to get the maximum value, and the corresponding hour to it,
I tried using Aggr(Max(value),sub_name) but it doesn't work

My end result should be
Max online fans are at 11 - 285.

I have thought of the peek function, but I am not sure

Any help will be highly appreciated.

-Angel

[devarasu07]

Try like this,

=max(total aggr(sum(value), sub_name))

[jonathandienst]

To get the sub_name with max value:

FirstSortedValue(sub_name, -value)

The maximum value:

Max(value)

[tomovangel]

this gives me 180 600 ( which is the sum of all days)
It doesn't work...

[tomovangel]

the Max(value) gives me the maximum value, but it doesn't give me the sub_name...

and FirstSortedValue(sub_name, - value) returns 2 ( which is not right)

[antoniotiman]

Hi Angel,

You need to Aggr per Date, like this

Aggr(FirstSortedValue(DISTINCT sub_name,-value),end_date_pacific)

Regards,

Antonio

[tomovangel]

Nope, This returns    -

...

-Angel

[pathiqvd · Accepted solution]

Hi,

Try this,

=FirstSortedValue(DISTINCT sub_name,-Value&sub_name)&'-'&max(Value)

Regards,

[antoniotiman]

Where You want to use expression ?

If in Text Box then add Max( to previous expression.

[tomovangel]

Thanks, this is giving me 

10 - 334 ( which is what I expected, I am going to check if it is correct)
Thank you Iakshmipathi p !

Regards,l

Ange