Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER 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
dilipranjith
Partner
Partner

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()

dilipranjith
Partner
Partner

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