Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

josephinetedesc
Contributor III

Which colour takes precedence?

Hi all

I want Type A and Type Be to show in different colours. as per Header1

but

when I select by Department I lose the colour ???

Jo

Header 1Header 2

Capture1.PNG

Capture2.PNG
1 Solution

Accepted Solutions
MVP
MVP

Re: Which colour takes precedence?

Try:

=if(getselectedcount(DEP) and DEP=DEP,Yellow(),Only({1}if( Type = 'A', RGB(102,153,255), RGB(166,218,140))))

6 Replies
MVP
MVP

Re: Which colour takes precedence?

Try color expression with set {1} like:

=Only({1} if(Type = 'A', RGB(102,153,255), RGB(166,218,140)))

josephinetedesc
Contributor III

Re: Which colour takes precedence?

yes .. that works - but having done that  - the colour showing the DEP selected was visually good!  Can I do both in some way???

Jo

MVP
MVP

Re: Which colour takes precedence?

Sorry, I could not follow. Could you explain a bit more?

josephinetedesc
Contributor III

Re: Which colour takes precedence?

If you look at the second image (Header B) - When DEPA selected then - then DEPA is highlighed in blue - which you don't want in blue - but could be useful if it was in another colour.

Jo

MVP
MVP

Re: Which colour takes precedence?

Try:

=if(getselectedcount(DEP) and DEP=DEP,Yellow(),Only({1}if( Type = 'A', RGB(102,153,255), RGB(166,218,140))))

josephinetedesc
Contributor III

Re: Which colour takes precedence?

Yest thank you - that works beautifully

Community Browser