Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top 5 with multiple dimensions

Hi,

I'm trying to show the top 5 opportunities (by TCV) and the rest as 'Others'.

The attributes are as below:

Dimensions: Opportunity Name, Country, Business Unit, Rev. Start Date, Close Date

Measures: TCV, Term (Months), Annual Value, 2017, 2018, 2019+

Top 5.png

The problem is that I want to show values for all the attributes for the top 5 opportunities, but values for just TCV, Term (Months), Annual Value, 2017, 2018, 2019+ for 'Others', as the dimensions differ between opportunity.

Dimension limits do not work with multiple dimensions as it shows an 'Others' for every combination of dimensions. I have been unable to get AGGR and RANK to work with multiple dimensions as well.

Is anyone able to help out?

Many Thanks,

Qlik User

1 Reply
lundgrenmatt
Contributor
Contributor

Was anybody able to help solve this? I'm struggling with the same issue