Discussion board where members can get started with Qlik Sense.
I am stuck with a chart, I tired to get the Top 3 sum(hour) overall the years:
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,
Go to 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
So simple, I didn't thought I could do that with dimensions !
I uncheck 'Show others'
Thank you so much !