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: 
bhaskarsharma03
Creator
Creator

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

Hi,

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

Regards,

Bhaskar

3 Replies
bhaskarsharma03
Creator
Creator
Author

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)


talk is cheap, supply exceeds demand
bhaskarsharma03
Creator
Creator
Author

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