Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Robin_P
Contributor
Contributor

Pivot table background - Cell color based on other cell values

Dear all,

First post here, I am a Qlik Sense beginner...

I would like to color pivot table cells' background, based on this cell and other cells' comparison.Webp.net-resizeimage.jpg

You will find attached a drawing of what I am trying to achieve, I hope you can help !

Best Regards,

Robin

Labels (2)
1 Reply
Wlad_Masi
Employee
Employee

You can color using functions like Blue(), Red() and etc, as well as color codes.
You will have to think in a formula for the entire column since you won't be able to set a color cell by cell.
Do you a pivot table already created in Qlik Sense?
Can you send us a screen shot of it ans let us know what you want to see there, so we can try helping you in the actual file?

Based on your object and the expected result we may have a different way of doing it.
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.