topic Re: Making one value in one field a persistent color in QlikView

Making one value in one field a persistent color

Wed, 17 Dec 2014 20:14:18 GMT

Hi all - I would like to make one value ("ERROR") in one field ("System Messages") persistently colored red. I don't care about a set color scheme for the rest of the values, just for "ERROR". How can I set the color for "ERROR" such that it will always display in red in a particular graph? Thanks!

Re: Making one value in one field a persistent color

sebastiandperei — Wed, 17 Dec 2014 20:31:01 GMT

En español?

Andá a:

y en la definición, tipeá:

if ([System Messages]='ERROR', RED())

Re: Making one value in one field a persistent color

Wed, 17 Dec 2014 20:36:24 GMT

Muchisimas gracias señor - esta perfecto! Funciona exactamente como quiero.

Re: Making one value in one field a persistent color

Wed, 17 Dec 2014 20:51:13 GMT

Una pregunta mas - sabes como puedo colorear mis selecciones activas? Por ejemplo, si quiero que todas mis selecciones entre [System Messages] estara azul.

Re: Making one value in one field a persistent color

sebastiandperei — Wed, 17 Dec 2014 22:36:42 GMT

English or spanish?

Ok, use:

if ([System Messages]=Only({1}[System Messages]), Blue())

Re: Making one value in one field a persistent color

Wed, 17 Dec 2014 22:40:08 GMT

Either one is fine

What does the Only function do there? Ideally I'd like to combine both of these formulas to color my current selections in the [System Messages] field and the "Error" value as well.