topic Re: Persistent colors / Cyclic Group / Fast Change in QlikView

Persistent colors / Cyclic Group / Fast Change

Tue, 30 Apr 2013 07:05:01 GMT

Hi,

I'm trying to create a chart with Fast Change (Bar, Pie). I'm using a Cyclic Group to cycle through all the dims. Now, for the dim business units I have defined fixed colors in an inline table. Works well. But, I'm having trouble to keep the colors correct in the Pie chart when switching to other dims than the business unit. It shows a multicolored legend and black pie chart (default color probably). This doesn't appear in the Bar chart (it stays blue for all dims), only with Pie. Check the code on the background color of the expression. Take a look at example. Thx, Zach.

Re: Persistent colors / Cyclic Group / Fast Change

alexandros17 — Tue, 30 Apr 2013 07:22:35 GMT

to control everything set always alternatives so if not 'Business Unit I've used rgb(100,100,100), set your color and it works

If(GetCurrentField([Cyclic_Dims])='Business Unit', RGB(R, G, B), rgb(100,100,100))

hope it hrelps

Re: Persistent colors / Cyclic Group / Fast Change

Tue, 30 Apr 2013 07:55:24 GMT

Hi, I would prefer not to set an alternative. The alternative should be the default color scheme. For the Bar chart this works out as I expected. For the Pie chart not. When I use a fixed alternative the whole Pie (logically) is in one color. If I leave out the alternative the Pie's legend shows as multicolored with default colors (as I want it do be), only it doesn't pull through to the individuel pie's. Any other ideas? Thanks again, Zach.

Re: Persistent colors / Cyclic Group / Fast Change

Anonymous — Tue, 30 Apr 2013 13:08:45 GMT

Hi,

what about setting the colors manually for each occurrences of all the possible dimensions?