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

Visual Cues across a row based on a specific column value

Wed, 29 Apr 2015 14:26:49 GMT

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.

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

Wed, 29 Apr 2015 14:48:38 GMT

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

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

Anonymous — Wed, 29 Apr 2015 15:05:30 GMT

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

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

Wed, 29 Apr 2015 15:11:37 GMT

Mike,

That worked beautifully. Thank you for your help.

Jeff

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

Wed, 29 Apr 2015 15:21:58 GMT

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

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

Anonymous — Wed, 29 Apr 2015 15:24:37 GMT

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.

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

Wed, 29 Apr 2015 15:27:24 GMT

Got it now, makes sense.