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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Toshi_Jain_2511
Contributor
Contributor

How to change the colour of data in a cell using Pivot table

Hi  All,

I am a Qliksense Developer and a learner.
I have one query on how can I assign colour to each cell in a Pivot table.
Example: I have two columns 

  Status    
  Low Medium  High
Risk      
Low 1 2 3
Medium 4 5 6
High 7 8 9

 

I want to assign text value 1 Black color as it is Low-Low
Low-Medium i.e. for value 2 I want to assign green color 
and Low -High i.e. value is 3 ,green color and so on for rest of the combinations.

Can someone please help me with this.
I have tried if condition but the header color got changed.
Thanks in Advance.

1 Reply
Ray_Strother
Support
Support

Hello ,

Please review the help site link below on how to change color via expressions.
https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expressio...

Thanks