Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Visual Cues - IF

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Visual Cues - IF

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.

View solution in original post

2 Replies
Highlighted
Not applicable

Re: Visual Cues - IF

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.

View solution in original post

Highlighted
MVP
MVP

Re: Visual Cues - IF

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 😉