Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table conditional formatting based on 80/20 percentage

Hi,

I have a pivot table where I have categories on rows and countries on columns. I have presented the cost by each category and country. Take a look at the below table for example

8020.PNG.png

I want three kind of conditional formatting here

1) For each cell in row(Category), If the cost contributes to the 80% of total cost for that row, format the background to be yellow

2) In another copy of the same table, for each column (country) I want the background of a cell to be colored orange if the cost amount of that cell contributes to the 80% of total cost for that column (country)

3) In another copy of the same table, I want the background of a cell to be colored red, if it contributes to the 80% of the overall cost (All categories, all countries)

0 Replies