topic Visual Cues Query in QlikView

Visual Cues Query

Anonymous — Tue, 05 May 2015 07:08:02 GMT

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

Re: Visual Cues Query

jpenuliar — Tue, 05 May 2015 07:39:08 GMT

Hi Phil,

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

Re: Visual Cues Query

vikasmahajan — Tue, 05 May 2015 07:39:52 GMT

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

Re: Visual Cues Query

vikasmahajan — Tue, 05 May 2015 07:52:48 GMT

pfa image

Re: Visual Cues Query

Anonymous — Tue, 05 May 2015 08:15:48 GMT

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 :

Re: Visual Cues Query

vikasmahajan — Tue, 05 May 2015 09:16:09 GMT

Please Find sample Give in Text Colour.

Vikas