Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Colour dimension pivot table

Hello,
I need to color the entire row of my pivot, but if the "Prod" dimension meets a certain condition; including the dimension.

pivot color.png

Labels (1)
4 Replies
dplr-rn
Partner - Master III
Partner - Master III

in qliksense you have to do conditional color for each column

so something like below in the background color field for each column

if(yourcondition,white(),rgb(yourcolor))

Ronald
Contributor III
Contributor III
Author

The columns it ok, but the dimension don´t colour; I need colour in the dimension by condition, for example; if (Prod='NNN')  put colour blue()

dplr-rn
Partner - Master III
Partner - Master III

i am not sure. 

i tried this expression for background color for 2 columsn 1 dimension and other measure if(ProductName='Chai', blue(),white())

so the color expression should work for any dimension after product (e.g. wont work for category name)

 

Capture.PNG

Ronald
Contributor III
Contributor III
Author

thanks, but, where Do I put the expression, because only in the measures can I change the color