Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

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

View solution in original post

2 Replies
micheledenardi
Specialist II
Specialist II

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

View solution in original post

Not applicable
Author

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

qlik.screen.PNG

I uncheck 'Show others'

Thank you so much !