Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bimanbeginner
New Contributor II

Colours in Chart

Hi There

How do you keep the colours of a chart dynamic.

I want good to always be green average amber and bad red.

1 Solution

Accepted Solutions
pradosh_thakur
Valued Contributor III

Re: Colours in Chart

Try this instead

check the back ground color of the expression

regards

Pradosh

5 Replies
pradosh_thakur
Valued Contributor III

Re: Colours in Chart

Hi

pfa

add pick(match(Status,'Good','Average','Bad'),1,2,3) in the sort tab

regards

Pradosh

bimanbeginner
New Contributor II

Re: Colours in Chart

Hi Pradosh

In a case like the attached model when there is no data for the one month 201704 for average then it is not dynamic...

Highlighted
pradosh_thakur
Valued Contributor III

Re: Colours in Chart

presentation -> uncheck supress zero values

pradosh_thakur
Valued Contributor III

Re: Colours in Chart

Try this instead

check the back ground color of the expression

regards

Pradosh

bimanbeginner
New Contributor II

Re: Colours in Chart

Thank you that works Perfect!!!

Community Browser