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

[#1]

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

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,

Olivier

[micheledenardi · Accepted solution]

Create a new barchart with this characteristics:

One dimension: year&'-'& monthName

One measure: sum(hour)

After that set these limit on the year-month dimension

[#3]

So simple, I didn't thought I could do that with dimensions !

I uncheck 'Show others'

Thank you so much !