Discussion Board for collaboration related to QlikView App Development.
I have the following table
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.
Go to Solution.
Add expression background color expression:
if(Status = 'Completed', Blue(), if(Status = 'In Progress', Green(), LightGray()))
did you try this on the background colors of the expression:
As Youssef mentioned, you can set the background color of the expression.
Please find attached file.