Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III

TOP 10 on a KPI based on the Graph's Revenue

Hi

I Would like to only Show the Top 10 revenue based on the Graph below per Client. And only per certain revenue earners:

This is my Current Formula: 

Sum({<fleettypenumber={'X550','X250GL','X250CL','X350','X400','X500','X575','X600','X740','X745','X999'}>}DrValue)

How will i incorporate Only the Top 10 Clients into my current formula?

Thanks in Advance

HereWeGoAgain_0-1618838504375.png

 

 

2 Replies
Dalton_Ruer
Support
Support

I'm a little confused as to exactly what you are trying to accomplish. 

1. With a BAR CHART for the measure you can set an absolute number of how many values to show like 10 if you sort the chart based on the value you will only see the highest 10. 

2. There is a RANK function that you can get help on here: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Ranki...

3. If your list of Revenue Earners is a fixed set that doesn't fluctuate often you can create a flag or other field in your load script so you don't need the complexity in any of your charts. 

If (Match(PENumber, 'X550','X250GL','X250CL','X350','X400','X500','X575','X600','X740','X745','X999'...) > 0, PENumber, NULL()) as PENumbersICareAbout

If (Match(PENumber, 'X550','X250GL','X250CL','X350','X400','X500','X575','X600','X740','X745','X999'...) > 0, Dual('Yes', 1), Dual('No', 0)) as PENumbersICareAboutFlag

4. You could create a Master Dimension that is like the PENumbersICareAbout field from 3. 

HereWeGoAgain
Contributor III
Contributor III
Author

@Dalton_Ruer Hi

I would like to get the top 10 revenue for clients, but only on specific vehicle in the following formula:

Please note:

FleetTypenumber -- is specific vehicles

Current Formula:

Sum({<fleettypenumber={'X550','X250GL','X250CL','X350','X400','X500','X575','X600','X740','X745','X999'}>}DrValue)

So i will basically need the formula to only look at the TOP 10 clients based on revenue for the specific vehicles.

*on the bar chart i used the Fixed limitations and set it to 10, but cannot do the same on the KPI

Hope this makes sense