Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making one value in one field a persistent color

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!

1 Solution

Accepted Solutions
sebastiandperei
Specialist
Specialist

En español?

Andá a:

y en la definición, tipeá:

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

View solution in original post

5 Replies
sebastiandperei
Specialist
Specialist

En español?

Andá a:

y en la definición, tipeá:

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

Not applicable
Author

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

Not applicable
Author

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

sebastiandperei
Specialist
Specialist

English or spanish?

Ok, use:

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

Not applicable
Author

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.