17 Replies Latest reply: Aug 10, 2017 5:23 AM by Caio Engelhardt Caminoski RSS

    Aggr or max ?

    Angel Tomov

      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))Screenshot_1.png
      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