topic Re: Maintain Same Colors across different pie charts in QlikView

Maintain Same Colors across different pie charts

Thu, 23 Jun 2011 18:16:18 GMT

Hi All,

I have a Dimension called Region and I want to calculate Hires and Turnover according to this dimension.

2 of the Regions have zero values for Turnover. As a result when I make separate pie charts to calulate Turnover and Hires, the colors on the legend corresponding to each region are different. Please have a look at the attached QVW for details.

Is there some color setting on the chart using which I can maintain the same colors for a particular region on both charts.

For eg. Australia should appear as Red in both the charts.

Thanks,

Neeraj

Re: Maintain Same Colors across different pie charts

johnw — Thu, 23 Jun 2011 18:30:04 GMT

I didn't expect this to work, but it looks like checkmarking "Persistent Colors" on the Colors tab on both charts does the trick.

If you want explicit control over the color of each region, you could code it as a background color expression:

if(Region='Australia',red()
,if(Region='Asia',rgb(130,140,150)
...

Or you could define the colors in the script, either with an inline load or maybe a load from a spreadsheet:

RegionColors:

LOAD * INLINE [
Region,R,G,B
Australia,200,100,100
Asia,130,140,150
...

And have a simpler background color expression:

rgb(R,G,B)

Re: Maintain Same Colors across different pie charts

kaushiknsolanki — Thu, 23 Jun 2011 18:32:34 GMT

Hi,

Checkout this.

Regards,

Kaushik Solanki

Re: Maintain Same Colors across different pie charts

nagaiank — Thu, 23 Jun 2011 18:33:41 GMT

Have you seen this article http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/ ?

Hope this helps

Re: Maintain Same Colors across different pie charts

Thu, 23 Jun 2011 18:46:42 GMT

Thanks Kaushik and John for the prompt response. I tried the same solution as suggested by John , but did not check mark 'Persistent Colors'. Thanks a lot.

Regards,

Neeraj