Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor II

Re: Colours in Chart

Try this instead

check the back ground color of the expression

regards

Pradosh

Learning never stops.
5 Replies
pradosh_thakur
Honored Contributor II

Re: Colours in Chart

Hi

pfa

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

regards

Pradosh

Learning never stops.
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...

pradosh_thakur
Honored Contributor II

Re: Colours in Chart

presentation -> uncheck supress zero values

Learning never stops.
pradosh_thakur
Honored Contributor II

Re: Colours in Chart

Try this instead

check the back ground color of the expression

regards

Pradosh

Learning never stops.
Highlighted
bimanbeginner
New Contributor II

Re: Colours in Chart

Thank you that works Perfect!!!

Community Browser