topic Re: Change in colors on Cyclic drill down option(Dimensional Grouping) in QlikView

Change in colors on Cyclic drill down option(Dimensional Grouping)

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have an concern regarding color codes in a bar chart with a cyclic drill down option.

I have two dimensions and defined with two sets of color codes for each,On flip option the same should reflect ,but since it is a flip and two set of colors are not implemented together.

Is their any options to implement my requirements.

Please find the attached source n QVW.

Thanks In advance.

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

sunny_talwar — Mon, 26 Feb 2018 13:53:09 GMT

May be try something like this

http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

kvr9 — Mon, 26 Feb 2018 13:59:46 GMT

Hi Sunny,

Thank you for your quick response.

Can you please help me how it works on my requirement (Cyclic drill down)

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

sunny_talwar — Mon, 26 Feb 2018 14:03:40 GMT

What do you mean?

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

kvr9 — Mon, 26 Feb 2018 14:18:29 GMT

I have gone through the article which you have shared, but I'm not sure how it works for my requirements( i.e two different set of colors for a dimensions grouped in a cyclic flip option)

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

sunny_talwar — Mon, 26 Feb 2018 14:23:15 GMT

Check the attached

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

kvr9 — Tue, 06 Mar 2018 12:49:41 GMT

Hi Sunny,

Thank you .

As suggested in the attachment ,I have to create a color code via excel or inline.

But I dnt want to use the color code in script as I have many variations in the color code , also I Used a expression to sort in a order.

Can you please suggest some other alternative.I have tried using defined color codes but due to persistent option it is changing .

Please find the attracted qvw.

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

sunny_talwar — Tue, 06 Mar 2018 12:53:31 GMT

As suggested in the attachment ,I have to create a color code via excel or inline.

What did I do? Didn't I load the color from the Excel file? I am not sure I follow...

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

kvr9 — Tue, 06 Mar 2018 13:27:39 GMT

I think you have defined the color codes in script

Re: Change in colors on Cyclic drill down option(Dimensional Grouping)

sunny_talwar — Tue, 06 Mar 2018 13:31:48 GMT

This is the script I used

LOAD Country,

Product,

Vendor,

Sale

FROM

[COLOR.xlsx]

(ooxml, embedded labels, table is Sheet1);

Directory;

LOAD Product,

Rp,

Gp,

FROM

COLOR.xlsx

(ooxml, embedded labels, table is Sheet2);

Directory;

LOAD Vendor,

Rv,

Gv,

FROM

COLOR.xlsx

(ooxml, embedded labels, table is Sheet3);

The script in red are getting picked from the Excel file....not sure why you think they are defined in the script?