How to change Bar Chart Colours with an underlying dimension

[kfahri342]

Hi,

I have the following table

Status	Name	Date of Completion
Completed	Name 1	Q1-2018
Completed	Name 2	Q1-2018
In Progress	Name 3	Q3-2018
TBC	Name 4	TBC

Using this table, I have made a Barchart in Qlikview with the following qualities:

- X Axis = Date of Completion

- Y Axis = Count(Name)

I want to introduce colours to my barchart, so once a name is completed it turns blue, if in progress it is green or if it is TBC then orange.

I thought I could use another Dimension ["Status"] to drive the colour changes - but I don't actually want to include this on the bar chart and because of that it doesn't seem to work.

Any ideas?

Many Thanks

Kozan

[YoussefBelloum]

EDITED

Hi,

did you try this on the background colors of the expression:

=if(Dimension_field='Completed',blue())

[binujose1982]

Hi Kozan,

As Youssef mentioned, you can set the background color of the expression.

Please find attached file.

Regards,

Binu

[shilpan · Accepted solution]

Add expression background color expression:

if(Status = 'Completed', Blue(), if(Status = 'In Progress', Green(), LightGray()))