# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor III

## Background colour formatting for a dimension in pivit table

I have colour coding for expression and based on the colour on pivot table the dimension colour should dynamically change. If any one row have red() then dimension background colour should show red() else green()

I have used the below expression but it is not working properly.

Sample :

=if(if(Appendix='Appendix V' and Count({<[B(1)]={'Do Not Comply'}>}No)>0 ,rgb(205,92,92)) =rgb(205,92,92) or

if(Appendix='Appendix V(C)' and Sum(If(VC.F22 = 'CV Submitted by Bidder', Responses0))<4,rgb(205,92,92)) =rgb(205,92,92) ,rgb(205,92,92),rgb(0,255,0))

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Background colour formatting for a dimension in pivit table

Check attached... I did it for just one of the expressions... but I am sure you will be able to apply the conditional logic in the background expression to make it work for other selections also

6 Replies
Highlighted
MVP

## Re: Background colour formatting for a dimension in pivit table

Would you be able to share a sample qvw to look at this?

Highlighted
New Contributor III

## Re: Background colour formatting for a dimension in pivit table

PFA sample. Color coding should be applied for dimension based on the colors applied on expressions. In a row if any of the color is red then dimension should be red......same for the yellow else green.

Highlighted
MVP

## Re: Background colour formatting for a dimension in pivit table

Check attached... I did it for just one of the expressions... but I am sure you will be able to apply the conditional logic in the background expression to make it work for other selections also

Highlighted
New Contributor III

## Re: Background colour formatting for a dimension in pivit table

Great! Thank you very much Sunny. Its working great.

Highlighted
New Contributor III

## Re: Background colour formatting for a dimension in pivit table

Hi Sunny! But as per the attached file whenever the value is NA it should not consider it and the output of color coding should be based on remaining color codes.

Highlighted
MVP

## Re: Background colour formatting for a dimension in pivit table

Not sure I understand? Are we still talking about the dimension?