Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Visual Cues across a row based on a specific column value

I'm attempting to use a visual cue to highlight an entire row based on the value in a specific column (i.e. Variance %) that is greater than a specific amount. If I use the following example can anyone tell me if this is possible.

Conditional Formatting.png

1 Solution

Accepted Solutions
lubicz99
Valued Contributor

Re: Visual Cues across a row based on a specific column value

Hi Jeff,

I would use the background color option. You can use it on either a dimension or expression.  The expression can even be on a field that is not even in the current chart.  It is a little misleading, when you click on the plus next to your dimension or expression, the items are greyed out. Just highlight the Background Color, Text Color or Text Format you want to affect and hit edit.  Here is one of my sample background to change my dimension to highlight yellow.

=if([Procedure Code Type]='CPT',yellow())

You can change font color and make it bold as well using the Text Color like this

=if([Procedure Code Type]='CPT',blue())

Bold on Format

=if([Procedure Code Type]='CPT','<B>')

Hope that helps

6 Replies
Not applicable

Re: Visual Cues across a row based on a specific column value

Rather than using a visual cue, would an expression for background color be a better approach?

lubicz99
Valued Contributor

Re: Visual Cues across a row based on a specific column value

Hi Jeff,

I would use the background color option. You can use it on either a dimension or expression.  The expression can even be on a field that is not even in the current chart.  It is a little misleading, when you click on the plus next to your dimension or expression, the items are greyed out. Just highlight the Background Color, Text Color or Text Format you want to affect and hit edit.  Here is one of my sample background to change my dimension to highlight yellow.

=if([Procedure Code Type]='CPT',yellow())

You can change font color and make it bold as well using the Text Color like this

=if([Procedure Code Type]='CPT',blue())

Bold on Format

=if([Procedure Code Type]='CPT','<B>')

Hope that helps

Not applicable

Re: Visual Cues across a row based on a specific column value

Mike,

That worked beautifully.  Thank you for your help.

Jeff

Not applicable

Re: Visual Cues across a row based on a specific column value

What is the expression to do both font and bold formatting for text?

lubicz99
Valued Contributor

Re: Visual Cues across a row based on a specific column value

You have to put the expression under Text Color to change color and an expression under Text Format to bold.  Note 3 expressions above.  One for each plus extended.

Not applicable

Re: Visual Cues across a row based on a specific column value

Got it now, makes sense.

Community Browser