Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kfahri342
New Contributor III

How to change Bar Chart Colours with an underlying dimension

Hi,

I have the following table

StatusNameDate of Completion
Completed

Name 1

Q1-2018
CompletedName 2Q1-2018
In ProgressName 3Q3-2018
TBCName 4TBC

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

1 Solution

Accepted Solutions
Luminary
Luminary

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

Add expression background color expression:

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

3 Replies
YoussefBelloum
Esteemed Contributor

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

EDITED

Hi,

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

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

Highlighted
binujose1982
New Contributor III

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

Hi Kozan,

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

Please find attached file.

Regards,

Binu

Luminary
Luminary

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

Add expression background color expression:

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