Set color in bar chart by data field

[schmidtj]

Hi,

i have a bar chart with a stacked dimension on the.

I would like to give each stack in a bar a pre-defined color.

The color is already defined in a data-field.

For example i have the following dimension in my data script:

[DIM_STATUS]:

LOAD

     id,

     name,

     color

FROM [$(v_QVD_Path)/Dimensionen\xxx.qvd] (qvd);

That dimension i am stacking in my bar chart and i would like to set the color which is in the data-field 'color'.

Is that somehow possible?

[Ivan_Bozov]

Hi! Perhaps this will help: Assigning colors to master dimension values ‒ Qlik Sense

[rittermd]

There is a good extension called Bars Plus that I have used that makes this fairly easy to do.  The new Dimension colors functionality in the June 2017 release may also work for you. 

[TKendrick20]

How is your Color field formatted? I know Qlik Sense plays nice with the RGB(XX,XX,XX) format.

[ahaahaaha]

Hi,

May be like as at attached file?

[schmidtj]

Ok, i used the color by formular feature of Qlik Sense and i forgot the '#'.

The color is formatted by web colors.

It is working fine now - thanks for all the feedback.

However when i do it like this, a legend is not displayed.

Is that a bug or a 'feature'?!?