Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pie Charts conditional colours

Hi guys

I have a pie chart that has results Yes No and N/A

When its not drilled down using sorts I have the colours as Yes RED No BLUE and N/A as YELLOW

thats perfect --

But when I drill down my options, say for example Yes is no longer part of my data range,  the colours promote up the spectrum so No becomes Red and N/A becomes BLUE

I wish to lock this down so Yes will Always be RED , No BLUE and N/A YELLOW

These yes/no/n/as are pulled from a column in an Excel spreadsheet

Can anyone help with this ?

Thanks


Anne

1 Solution

Accepted Solutions
dennisnet
Not applicable

Pie Charts conditional colours

Hi Anne,

Did you try playing around with the "Presisistent Colors" option on the Colors tab?

If that doesn't work for you, you can aways add a color to your expression using the Background Color option in the Expression tab.

4 Replies
rahulgupta
Not applicable

Re: Pie Charts conditional colours

Hi!

U have to write a code  in background color Options of expression.

Refer the attached application.It has got something same as u want.

dennisnet
Not applicable

Pie Charts conditional colours

Hi Anne,

Did you try playing around with the "Presisistent Colors" option on the Colors tab?

If that doesn't work for you, you can aways add a color to your expression using the Background Color option in the Expression tab.

Not applicable

Re: Pie Charts conditional colours

Thanks Guys

Presisistent colours is the way for me I think

Thanks

stig1984
Not applicable

Re: Pie Charts conditional colours

Thanks for this - I've made good use of this script.