topic Re: Visual Cues ignoring ARGB in QlikView

Visual Cues ignoring ARGB

helen_pip — Mon, 27 Feb 2017 21:13:34 GMT

Dear Qlikview user

I am using visual cues to show whether a value has exceeded a target or not with the colors red or green

Although the visual cue is showing the correct colors, it appears to be ignoring the ARGB function I have put in as a calculated color

ARGB(80,117,155,115) = Green

ARGB(80,255,112,200) = Red

Does anyone know if visual cues does not allow for ARGB?

Unfortunately, I cannot use Background color under expressions, due to the complexity of my table and data structure

Kind Regards

Helen

rubenmarin — Mon, 27 Feb 2017 21:48:56 GMT

Hi Helen, I tried and argb doesn't work for me either.

In case you don't know, you can use label name to reference the expression, so the background color can be:

If([ExpressionLabel]>0, ARGB(80,117,155,115) , ARGB(80,255,112,200))

If the expression label is calculated it can also be:

If([$(=ExpressionLabel)]>0, ARGB(80,117,155,115) , ARGB(80,255,112,200))

You can add a condition to keep '0' in black.

Hope this helps!

helen_pip — Mon, 27 Feb 2017 22:02:05 GMT

Hello Ruben

Thanks for testing whether ARGB works on visual cues...I thought I was doing something wrong, but could not see it

Thanks for the tip about the expression label

As an interim measure I have just chosen a green colour which gives the appearance of our ARGB variable v_colour_pass_target

Thanks

Helen