Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)