Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

philmywallet
New Contributor III

Visual Cues Query

Hi

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

Any ideas??

Thanks

Phil

Tags (2)
5 Replies
jpenuliar
Valued Contributor III

Re: Visual Cues Query

Hi Phil,

the sample file "Data Visualization" has a Speedometer example with RAG (KPI Tab>>Presentation property>>Segments)

vikasmahajan
Honored Contributor III

Re: Visual Cues Query

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

Vikas

vikasmahajan
Honored Contributor III

Re: Visual Cues Query

pfa image

philmywallet
New Contributor III

Re: Visual Cues Query

Vikkas

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 :Picture1.png

vikasmahajan
Honored Contributor III

Re: Visual Cues Query

Please Find sample Give in Text Colour.

Vikas

Community Browser