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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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 (1)
1 Reply
Wlad_Masi
Former Employee
Former 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.