topic RAG Values in QlikView

RAG Values

CHansford — Tue, 25 Aug 2015 17:45:15 GMT

Hi Qlik Community,

I'm pretty new to this Qlikthing and I must say I'm pretty impressed with it. Anyway I'm trying to change the background colour in a Straight Table to the field value (Red,Amber/Red,Amber,Amber/Green and Green) have managed to do it using a number value (1=Red through 5=Green) using Colourmix, but I just want to be able to use the Field value string. Any help or suggestions would be appreciated.

Re: RAG Values

swuehl — Tue, 25 Aug 2015 18:51:36 GMT

=Match(FieldValue, 'Red', 'Amber/Red', 'Amber', 'Amber/Green', 'Green')

should translate your FieldValue strings to numbers from 1 to 5. Replace FieldValue with your field name.

You can create a dual() value in the LOAD script:

LOAD

Dual( FieldValue, Match(FieldValue, 'Red', 'Amber/Red', 'Amber', 'Amber/Green', 'Green') ) as FieldValue,

...

Then you can use FieldValue directly in any function that needs a numeric value.

Re: RAG Values

CHansford — Wed, 26 Aug 2015 16:11:56 GMT

Swuehl, thanks for that, all worked a treat, now to find something harder to create