Color Coding of Bar charts on the basis of dimension

[#1]

Hi,

I have a products category with 3 levels of hierarchy.

L1          L2          L3

A           A1          A2

B           B1          B2

C           C1          C2

Now when i use the above levels as dimension :-

Bar for 'A' should show 'blue' color.

Bar for 'B' should show 'red' color.

Bar for 'C' should show 'green' color.

Now When I drill down in 'A'......bars for 'A1' & 'A2' & 'A3' should show shades of blue color.

similarly for 'B'....bars for 'B1' & 'B2' & 'B3' should show shades of red color.

similarly for 'C'......

How do i do it ?

Please help

[sujeetsingh]

u can use color functions as red(),green() and all.

[#3]

Please send me a sample code for 3 levels for 1 product.

Thanks in advance.

[hic]

This problem is described in one of my blog posts:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

HIC

[#5]

Hi,

Step1 - Make a Drill - Down Group of your dimension

Step2 - Create Bar chart using the group dimension created above

Step3 - In the COLOR tab of the chart select the options "MultiColored" and "Persitent Color"

You can select the color at the left hand side

Thanks,

[sujeetsingh]

Here is the file a sample in my previous post

[#7]

Hi Henric,

I am going through your post.....till then please tell me that will it work for stack chart ?

[hic]

Yes, it will. I used the attached script (test data + color definitions) and =HSL(Hue,Sat,Lum+lum) as bkgrnd color function.

HIC