# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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.

Olivier

Tags (3)
1 Solution

Accepted Solutions
Valued Contributor

## Re: Stuck with Top chart with 2 dimensions (Year,Month)

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

2 Replies
Valued Contributor

## Re: Stuck with Top chart with 2 dimensions (Year,Month)

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

Not applicable

## Re: Stuck with Top chart with 2 dimensions (Year,Month)

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

I uncheck 'Show others'

Thank you so much !