Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional formatting of top 80%?

Hi All,

I have a chart which shows the client name and revenue generated from client. If I want to highlight all those customers who contributed to 80% of profit, how can I do that. So basically I have two questions here

1) What is the expression to calculate all those customers who contributed to 80% of total profit

2) How to conditionally format the profit of customer so that it it contributes to 80% of total profit, make it red

I really appreciate your help

Regards

Arif

1 Reply
Not applicable
Author

Hi Arif,

you can use button with Pareto selection action or approach proposed by Mr. Witherspoon in this post: http://community.qlik.com/thread/1668

regards