topic Re: Retain background colour in QlikView

Retain background colour

Mon, 07 Jul 2014 07:26:13 GMT

I have a bar chart where the expression's background colour is set as follows;

if(wildmatch(Market, 'EMEA*'), RGB(141,170,203),if(wildmatch(Market, 'APAC*'), RGB(252,115,98),RGB(187,216,84)))

However, when I make certain selections in my list boxes, the colours can change. How do I fix the colours of the bars on the bar chart so they cannot be changed no matter what selection is made?

Re: Retain background colour

MK_QSL — Mon, 07 Jul 2014 07:45:05 GMT

Check enclosed file...

Re: Retain background colour

Mon, 07 Jul 2014 07:49:40 GMT

It's not actually the market field on my doc which impacts the colour. I have another field called 'Region' which impacts the colour

Re: Retain background colour

MK_QSL — Mon, 07 Jul 2014 08:06:40 GMT

Provide some sample dummy data !

Re: Retain background colour

ThornOfCrowns — Mon, 07 Jul 2014 08:19:59 GMT

Select the 'Persistant Colours' option in the Colours Tab.

Re: Retain background colour

its_anandrjs — Mon, 07 Jul 2014 08:28:10 GMT

Use Persistent color or you can use any inline table load for this also

Ex:-

Load * inline

[

Market,RED,GREEN,BLUE

EMEA,141,170,203

APAC, 252,115,98

Other,187,216,84

];

And then in the Background properties write

=RBG(RED,GREEN,BLUE)

Re: Retain background colour

Mon, 07 Jul 2014 08:30:51 GMT

it is ticked

Re: Retain background colour

Anonymous — Mon, 07 Jul 2014 08:41:58 GMT

Hi,

Its just my thought. Your condition might be satisfying else part whenever you do selection in Region. For example, If you select Australia which is not linked to market "APAC" or "EMEA", you will get RGB(187,216,84) as a background color.

Thanks