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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
sharmi1990
Contributor
Contributor

Remove Qlik Pivot Table color coding at aggregated level

Hi All,

I have a pivot table, where data is aggregated at multiple levels. I have added color coding to the lowest granular level. As we roll up the pivot table, I dont want the color to be applied at aggregated level.

Eg: As you see below PIVOT table, I dont want the aggregated data ie. 12.35 and 11.94 to be highlighted, even though the underlying granular data in those categories are highlighted in red. 

sharmi1990_0-1670900571766.png

 

 

Labels (2)
0 Replies