Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

We value your feedback – take our 5-minute QlikView modernization survey
Showing results for 
Search instead for 
Did you mean: 

Colour of dots on scatter chart by other dimension

Hi all

I have 2 charts the first one is a simple chart that shows sales opportunity value by the opportunity stage. By activation 'multicoloured' each stage is assigned a colour.

My second chart is a scatter chart showing every opportunity by its age and its value. I would like to colour each dot by referencing the associated opportunity stage so that the colours are consistent.

Any ideas how I might do this?

1 Reply

Override the color in both charts by using the Background Color option of the expression. Use something like Color(FieldIndex('Stage',Stage)) to give each stage its own color. Or load an small table with Stage and color like explained in this blog post: Colors in charts

talk is cheap, supply exceeds demand