Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Pick and Match color

I am using expression for color. pick and match function were used. Expression as the following:

pick(match(DRCNonSecList,'Corporates','Local Governments','Sovereigns'),RGB(204,102,119),RGB(68,119,170),RGB(26, 188, 156))

Seems to work fine until I click on other dimension like the following:

I think this is due to the selection of the colour

"pick(match(DRCNonSecList,'Corporates','Local Governments','Sovereigns'),RGB(204,102,119),RGB(68,119,170),RGB(26, 188, 156))"

is no longer valid. How do I make the color always valid in this case?

I was thinking to use

{<DRCNonSecList=>} to mix into pick and match functions so that regardless what dimension I am navigating to it will be always true and therefor the color will never change. However I can't figure out how this is possible. Please can any one advice?

1 Solution

Accepted Solutions

Re: Pick and Match color

You are right, try this

Pick(Match(Only({<DRCNonSecList = >}DRCNonSecList), 'Corporates', 'Local Governments', 'Sovereigns'), RGB(204,102,119), RGB(68,119,170), RGB(26, 188, 156))

2 Replies

Re: Pick and Match color

You are right, try this

Pick(Match(Only({<DRCNonSecList = >}DRCNonSecList), 'Corporates', 'Local Governments', 'Sovereigns'), RGB(204,102,119), RGB(68,119,170), RGB(26, 188, 156))

Not applicable

Re: Pick and Match color

Thanks Sunny!