Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III
‎2021-04-01 08:27 AM

Show only The total Revenue for Top 10 select in chart on KPI

Good Day

 

I would like to display the total revenue for the Top 10 Clients shown in die bar chart in a KPI (Right hand corner)

HereWeGoAgain_0-1617280007076.png

 

337 Views
0 Likes
2 Replies
yilmazmurat
Contributor III
Contributor III
‎2021-04-01 06:14 PM

Can you please try the expression below?

 

sum({<ClientField={"=rank(sum(revenueField),4)<=10"} >} revenueField)

292 Views
0 Likes
HereWeGoAgain
Contributor III
Contributor III
‎2021-04-07 10:42 AM
Author

@yilmazmurat  how will i include the following in your expression?

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

269 Views
0 Likes