topic How do i conditionally format the background color of a field on a straight table? in QlikView

How do i conditionally format the background color of a field on a straight table?

Wed, 07 Nov 2012 17:59:10 GMT

How do conditionally set the background color of a field on a straight table chart based on another field within the record?

Also, can the background color of an entire row on a straight table chart be set conditionally or will i have to set each field individually?

Thanks

Re: How do i conditionally format the background color of a field on a straight table?

Wed, 07 Nov 2012 18:09:53 GMT

Coniditional coloring can be done like the following:

=IF(RIGHT(Account_Number,1)='1', GREEN(), RGB(100,100,100))

Silly expression but you can use the THEN and ELSE to determine your colors. Notice that if the furthest right 1 character is 1 then the background will use the QV system function for the color GREEN, while if the character is not a 1 then it will use the explicitly defined RGB color value.

Your IF statements can be nested as they can in any circumstance like

=IF(MyExpression , GREEN(),

IF(MyOtherExpression, YELLOW(),

RED()))

There is no way I know of set the background color for the entire row conditionally.

Re: How do i conditionally format the background color of a field on a straight table?

Mon, 11 Mar 2013 20:07:09 GMT

To format the row, you just need to apply the same conditional colouring statement to each and every 'Used Dimension' in the 'Dimensions' tab or Expression.