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: 
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