topic Re: Pie Charts conditional colours in QlikView

Pie Charts conditional colours

Tue, 31 May 2011 11:00:48 GMT

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

Re: Pie Charts conditional colours

rahulgupta — Tue, 31 May 2011 11:20:05 GMT

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.

Pie Charts conditional colours

Anonymous — Tue, 31 May 2011 11:22:21 GMT

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.

Re: Pie Charts conditional colours

Tue, 31 May 2011 11:30:26 GMT

Thanks Guys

Presisistent colours is the way for me I think

Thanks

Re: Pie Charts conditional colours

stig1984 — Thu, 03 Aug 2017 14:20:50 GMT

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