Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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

Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Creator
Creator

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