topic Re: Which colour takes precedence? in QlikView

Which colour takes precedence?

josephinetedesc — Tue, 29 Aug 2017 03:35:38 GMT

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 ???

Header 1	Header 2

Re: Which colour takes precedence?

tresB — Tue, 29 Aug 2017 04:38:34 GMT

Try color expression with set {1} like:

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

Re: Which colour takes precedence?

josephinetedesc — Tue, 29 Aug 2017 04:51:44 GMT

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

Re: Which colour takes precedence?

tresB — Tue, 29 Aug 2017 05:04:42 GMT

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

Re: Which colour takes precedence?

josephinetedesc — Tue, 29 Aug 2017 05:21:38 GMT

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.

Re: Which colour takes precedence?

tresB — Tue, 29 Aug 2017 05:34:36 GMT

Try:

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

Re: Which colour takes precedence?

josephinetedesc — Tue, 29 Aug 2017 05:55:28 GMT

Yest thank you - that works beautifully