Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to color the entire row of my pivot, but if the "Prod" dimension meets a certain condition; including the dimension.
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))
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()
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)
thanks, but, where Do I put the expression, because only in the measures can I change the color