Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

stefan_fischer
New Contributor II

Change color schema in stacked bars

Hi,

charts in QlikView have a default color schema on stacked bars. I will change this color set with my own. In a listbox there are five entrys (AA, BB, CC, DD, EE) which should have fixed color. Click on AA will be open the next level (AA1, AA2). Now this level should have same color spectrum before. Can I also calculate the color below AA? Pls see color spectrum in attached pic.

AA:  v_NaturalYellow_AA = RGB(235,120,10); 

     AA1: v_NaturalYellow_AA1 = RGB(245,140,20); 

     AA2: v_NaturalYellow_AA2 = RGB(225,185,0);

     ...

BB: v_NaturalRed_BB = RGB(100,25,70); 

     BB1: 

     BB2:

     ...

CC: v_Natural_Blue_CC = RGB(0,100,135) 

     CC1: 

     CC2:

     ...

DD: v_Natural_Green_DD = RGB(100,125,45) 

     DD1: 

     DD2:

     ...

EE: v_Natural_Gray_EE = RGB(80,90,100) 

     EE1: 

     EE2:

     ...

Color_Schema.JPG.jpg

1 Reply
datanibbler
Esteemed Contributor

Re: Change color schema in stacked bars

Hi Stefan,

you can use any kind of formula to calculate RGB() colours in the formula_properties (on the "formula" tab of the dialog, just expand any of your formulas by clicking on the little cross - you can also make it dependent on the last selection by using the >> Getcurrentselections() << function

HTH

Best regards,

DataNibbler

Community Browser