0 Replies Latest reply: Jan 17, 2017 5:14 AM by Qlik User RSS

    Top 5 with multiple dimensions

    Qlik User

      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