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

      Hello,

       

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

       

      Aggr(if(rank(sum(hour))<=3,sum(hour)),year,monthName)

       

      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():

      qlik.chart.PNG

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

      qlik.table.PNG


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


      Thanks in advance,

      Olivier