Late reply, but did you try colormix wizard?
1. Open "Background color" property of the Expression
2. Click on ... in the Expression Definition, to see whole window
3. Go to File -> Colormix wizard
You can read more in help: https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Colormix_Wizard.htm
That is what I would like but ...
I have an expression: Count(Band of Interest)
For example - if the Band of Interest is 300+ then i want the count to be in RED, but if the Band of Interest is 0 then i want the count to be in Green.
So I will try count(of MinsWaited) as my expression to apy the colour to.
Ah maybe ...remove the secondary dimension ???
I think this is a bit more complicated ...
The expression is "count how many people have a WaitingTime of more than 60 mins, more than 90 mins, more than 100 mnis), so it is not a straight expression.
so to do this I used the Class function which calculated this automatically - it counts the number of patients within 100 minute bands.
I don't think the ClolorMix wizard can do this - I think I need to choose each colour within the band.
Values would be something like:
Person1 waited 40 mins
Person2 waited 20 mins
Person3 did not wait
so for example on the 31/1/2017 there were 14 people seen before their appointment time, 12 were seen within 30 mins of their appointment time, 23 were seen between 30 and 60 mins of their appointment time.
I think the only thing I can do is in the colors tab - change the colours.