Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to set a RAG status for few thresholds using Visual Cues, could someone point me in the right direction. I am sure this will be simple, just can't find it on the forum.
My expression is a percentage and I need it to show as below:
Less than 80% = Red
80% - 94.9% = Yellow
95% - 99.9% = Green
100% - 104.9% = Yellow
More than or equal to 105% = Red
the sample file "Data Visualization" has a Speedometer example with RAG (KPI Tab>>Presentation property>>Segments)
While define visual cues , click on expression window and use if condition like this
if (growth > 80 and growth < 94.9 , Yellow(),if( growth > and < , Green() , If(
This should solve your problem
Your script works but it returns the text of the colour ('RGB, 255,255,0') text, not the percentage and the colour.
Please see below :
Please Find sample Give in Text Colour.