Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
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
shilpan
Luminary Alumni
Luminary Alumni

Add expression background color expression:

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

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

EDITED

Hi,

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

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

binujose1982
Contributor III
Contributor III

Hi Kozan,

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

Please find attached file.

Regards,

Binu

shilpan
Luminary Alumni
Luminary Alumni

Add expression background color expression:

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