Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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