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.
Solved! Go to Solution.