Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Change Bar chart Color as per measures

Hi There

I want to change color of Bars as per the measures.

Please find attached screenshot for your reference,

I am looking for something like this ,

Budget = Green

Forecast = Orange

Actuals = Red

Thanks for your help.

1 Solution

Accepted Solutions
fawazeez
Contributor

Re: Change Bar chart Color as per measures

master measure.PNGCapture.PNG

12 Replies
sureshqv
Esteemed Contributor III

Re: Change Bar chart Color as per measures

attachment missing

ashishpalkar
Contributor II

Re: Change Bar chart Color as per measures

Added

sureshqv
Esteemed Contributor III

Re: Change Bar chart Color as per measures

did you tried colurs legend tab by measure?

sureshqv
Esteemed Contributor III

Re: Change Bar chart Color as per measures

here is the best example i found for you check this migh help you

create a dummy dim with expresion use pick match

Custom color by expression for two different expressions

ashishpalkar
Contributor II

Re: Change Bar chart Color as per measures

Yes, it doesn't mentioned which Color to use for specific measure.

sureshqv
Esteemed Contributor III

Re: Change Bar chart Color as per measures

try this

if(measure=measure1,rgb(127,255,127),if(measure=measure2,rgb(255,127,127)))

fawazeez
Contributor

Re: Change Bar chart Color as per measures

I think you can add attach colors to master measure .

Than in colors & legend section of chart you can say use library colors measure

ashishpalkar
Contributor II

Re: Change Bar chart Color as per measures

It shows bad field name for 'measure', we cannot define measure = measure1

fawazeez
Contributor

Re: Change Bar chart Color as per measures

master measure.PNGCapture.PNG

Community Browser