Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishna4bo
Contributor

change bar colors in bar chart

Hi All,

How to change bar colors in bar chart By Expression.(Qliksense)

Dimension: AffectedApplication

Measure 1:

=if(GetSelectedCount(Affected_Month)>0,Round(Sum([Overall Availability%])/Count([Overall Availability%]))&''& '%',Only({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%])&''& '%')

Measure 2:

=if(GetSelectedCount(Affected_Month)>0,

Round(Sum([Unavailability%])/Count([Unavailability%]))&''& '%',

Only({<Affected_Date={'$(=Max(Affected_Date))'}>}[Unavailability%])&''& '%')


I need green for 1st measure and blue for 2nd measure.

Regards,

Krishna

1 Solution

Accepted Solutions
mdmukramali
Valued Contributor II

Re: change bar colors in bar chart

Hi,

Create the Expression in Master Item and assign the color for each expression

2 Replies
mdmukramali
Valued Contributor II

Re: change bar colors in bar chart

Hi,

Create the Expression in Master Item and assign the color for each expression

devarasu07
Honored Contributor II

Re: change bar colors in bar chart

Hi,

try below method,

method 1: try to create your measure as master item (in this master item we can assign measure color)

method: try to apply color by expression option in your chart -->presentation--> color & legends --select custom color (by measure option) 

Color by expression ‒ Qlik Sense

Capture.JPG