topic Re: Visual Cues - IF in QlikView

Visual Cues - IF

Sunil_Kenth — Mon, 06 Feb 2012 16:14:42 GMT

Hi All,

I need some help with an IF statement to put into a visual cue on a straight table. I need the cells to highligh red if the KPI = Pick Accuracy and Pd 10 < 99.70%. I also need it to be green if KPI = Pick Accuracy and Pd 10 > 99.70%.

Thanks,

Sunil

Re: Visual Cues - IF

Mon, 06 Feb 2012 16:20:45 GMT

Hello sunil,

For that do to the expression click on the small + sgin and you will see the background colour option, there you need to write an expression like if(KPI= Pick Accuracy and Pd 10>99.70,Red(), Green()). This helps to highlight the whole cell background in the desired colour.

Hope this helps.

Re: Visual Cues - IF

swuehl — Mon, 06 Feb 2012 16:23:22 GMT

I believe it is better to use the color attribute expressions on expression tab, then.

Open e.g. the attribute for the background color by clicking on the plus sign next to the expression label, then enter something like

=if(KPI='Pick Accuracy', if( Pd10 < 0.997, red(), green())

Typing to slow 😉