Color rows of a straight table based on a value of a dimension

[bhaskarsharma03]

Hi,

I want to color the entire row based on the value of one dimension. Could you please help me do it?

Regards,

Bhaskar

[bhaskarsharma03]

Just to add on to the above query... the actual table has around 30 columns, and they keep on changing frequently, so adding Background Color in each and every dimension is not an ideal option.

What I am looking at is, writing the condition once, and the color is being picked up by the entire row.

Bhaskar

[Gysbert_Wassenaar]

Add the same Background Color expression to every dimension. There is no way to set this for the entire row once. You can put the expression in a variable and reuse the variable:

Variable: vColor: =if(Mod(ID,2)=0,QlikTechGray())

Expression: $(vColor)

[bhaskarsharma03]

This is what I have now... and have to make changes in every dim and expression as and when the taste of the user changes (or business requires it). Was looking for something that ensures it's done once and for all. Thanks anyway Gysbert. Let's see if others also have something share as well

Cheers,

Bhaskar