Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)