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: 
SarahFenton
Contributor
Contributor

Colour by expression within a drill down graph

Hi 

I've created a drill down bar chart that shows the number of deliveries that are On Time or Late.  If, for example, I select Late, this will then break into sub categories showing how late it was - eg up to 60 minutes late.  The graph seems to work as I want it to, however, when I drill down to the sub categories the graph remains all one colour.

I've used Master Dimensions for each level of the drill down and assigned the colours there - as you can see in the second chart, it knows there are 2 segments to display, just that the colours don't update.

Any help would be greatly appreciated.

Thanks 

Sarah

 

Top Level ViewTop Level ViewBy Sub Category (current)By Sub Category (current)By Sub Category (Required)By Sub Category (Required)

2 Replies
Channa
Specialist III
Specialist III

try

 

if(Dimensionality()=1 and sum(Sales)<150,RGB(151,255,255),if(Dimensionality()=2 and sum(Sales)<=20,RGB(0,238,0),if(Dimensionality()=3 and Sum(Sales)<=20,RGB(255,130,171))))

Channa
SarahFenton
Contributor
Contributor
Author

Hi Channa

I'm having trouble understanding the below and how to use it in my example.  Do you put this in the colour by expression section?

Would you be able to provide an example of how Dimensionality() works as part of a bar chart and it may help me to map it across to the data I'm using?

Thanks

Sarah