Qlik Community

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

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

1 Solution

Accepted Solutions
micheledenardi
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

2017-05-29 16_59_08-Qlik Sense Desktop.png

2 Replies
micheledenardi
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

2017-05-29 16_59_08-Qlik Sense Desktop.png

Not applicable

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

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

qlik.screen.PNG

I uncheck 'Show others'

Thank you so much !