Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Sunny,
Thank you for your quick response.
Can you please help me how it works on my requirement (Cyclic drill down)
May be try something like this
http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/
Hi Sunny,
Thank you for your quick response.
Can you please help me how it works on my requirement (Cyclic drill down)
What do you mean?
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)
Check the attached
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.
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...
I think you have defined the color codes in script
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?