Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kvr9
Creator
Creator

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

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.

1 Solution

Accepted Solutions
kvr9
Creator
Creator
Author

Hi Sunny,

Thank you for your quick response.

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

View solution in original post

9 Replies
sunny_talwar

kvr9
Creator
Creator
Author

Hi Sunny,

Thank you for your quick response.

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

sunny_talwar

What do you mean?

kvr9
Creator
Creator
Author

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)

sunny_talwar

Check the attached

kvr9
Creator
Creator
Author

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.

sunny_talwar

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...

kvr9
Creator
Creator
Author

I think you have defined the color codes in script

sunny_talwar

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,

    Bp

FROM

COLOR.xlsx

(ooxml, embedded labels, table is Sheet2);


Directory;

LOAD Vendor,

    Rv,

    Gv,

    Bv

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?