Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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!

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Making one value in one field a persistent color

En español?

Andá a:

y en la definición, tipeá:

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

View solution in original post

5 Replies
Highlighted
Specialist
Specialist

Re: Making one value in one field a persistent color

En español?

Andá a:

y en la definición, tipeá:

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

View solution in original post

Highlighted
Not applicable

Re: Making one value in one field a persistent color

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

Highlighted
Not applicable

Re: Making one value in one field a persistent color

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

Highlighted
Specialist
Specialist

Re: Making one value in one field a persistent color

English or spanish?

Ok, use:

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

Highlighted
Not applicable

Re: Making one value in one field a persistent color

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.