2 Replies Latest reply: May 29, 2017 11:15 AM by Olivier Candela RSS

    Stuck with Top chart with 2 dimensions (Year,Month)

    Olivier Candela



      I am stuck with a chart, I tired to get the Top 3 sum(hour) overall the years:




      I get the top 3 month per year, i can't find a way to get only the top 3 values, top() didn't work on the aggr():


      But I want to get the top 3 overall the years, here a screenshot from the table ( column = year, month, sum(hour) ):


      I'm new on Qlik Sense so I'm might miss an important option, feel free to correct me.

      Thanks in advance,