topic Re: How to change Bar Chart Colours with an underlying dimension in QlikView

How to change Bar Chart Colours with an underlying dimension

kfahri342 — Mon, 12 Mar 2018 16:15:21 GMT

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

Re: How to change Bar Chart Colours with an underlying dimension

YoussefBelloum — Mon, 12 Mar 2018 16:30:34 GMT

EDITED

Hi,

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

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

Re: How to change Bar Chart Colours with an underlying dimension

binujose1982 — Tue, 13 Mar 2018 03:11:48 GMT

Hi Kozan,

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

Please find attached file.

Regards,

Binu

Re: How to change Bar Chart Colours with an underlying dimension

shilpan — Tue, 13 Mar 2018 04:06:57 GMT

Add expression background color expression:

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