Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
timmarsh
Contributor III
Contributor III

How to set colour in bar chart

Hi guys, checked old answers first.

I have a bar chart with 2 dims. I am summing 2 counters across the dims.


I have a dimension - MonthYear. I also have a cyclical group.

I am summing two counters across each M-Y to display a percentage result.

When the result is below 0.95, I want the bar to be red, regardless of the cyclical chosen.

In chart properties, I've tried adding the below to the Dimension (MonthYear) background colour. I've used 0.59 as I can see some results above and below 0.59, so can visually confirm.

=IF(((sum(DS_Complete_Counter)/sum(DS_Record_Counter))<0.59),Red(), Green())

In the the cyclical dim, I've added the same test.

In Colours, I also changed the first colour to be calculated, using the same formula.

I cannot for the life of me to get this to work.

Thanks for any help!

Capture.PNG

1 Solution

Accepted Solutions
timmarsh
Contributor III
Contributor III
Author

Disregard! The ONLY place I hadn't checked was the background colour accessible from + drop down in Expression editor.


Found it as I'd kept my QV training scripts which I knew addressed it.


Cheers!

View solution in original post

1 Reply
timmarsh
Contributor III
Contributor III
Author

Disregard! The ONLY place I hadn't checked was the background colour accessible from + drop down in Expression editor.


Found it as I'd kept my QV training scripts which I knew addressed it.


Cheers!