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
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III

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

 

2 Replies
yilmazmurat
Contributor III
Contributor III

Can you please try the expression below?

 

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

HereWeGoAgain
Contributor III
Contributor III
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)