Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

Set color in bar chart by data field

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?

5 Replies
Ivan_Bozov
Valued Contributor

Re: Set color in bar chart by data field

rittermd
Honored Contributor

Re: Set color in bar chart by data field

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
Valued Contributor

Re: Set color in bar chart by data field

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

ahaahaaha
Honored Contributor

Re: Set color in bar chart by data field

Hi,

May be like as at attached file?

j_schmidt
Contributor

Re: Set color in bar chart by data field

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'?!?

Community Browser