topic Re: Background Color in a pie chart in QlikView

Background Color in a pie chart

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am building a pie chart and having and issue with the background color under the expressions tab. I have values called Issue Types and I created a set analysis to take out the values that I don't want. However, when I put the background color in, the pie chart shows the values that the set analysis took out. I am using the following formula in the "Background Color" expression:

=If(issue_type='PLandG',RGB(252,115,98),If(issue_type='GConfig',RGB(141,170,203),If(issue_type='MDB Config',RGB(187,216,84),If(issue_type='OnBC',RGB(255,217,47),If(issue_type='Con',RGB(102,194,150),if(issue_type='GLR',RGB(229,182,148),If(issue_type='P',RGB(231,138,210),If(issue_type='FC',RGB(179,179,179),If(issue_type='CA&R',RGB(166,216,2227),If(issue_type='TSC',RGB(171,233,188),If(issue_type='TDMSBandS',RGB(27,125,156),If(issue_type='OMSC',RGB(255,191,201),If(issue_type='P:P',RGB(77,167,65),If(issue_type='CA',RGB(196,178,214),If(issue_type='CR',RGB(178,36,36),If(issue_type='D',RGB(0,172,172),If(issue_type='CB',RGB(190,108,44))))))))))))))))))

Is their something missing from the formula that would be causing the chart to show the values that I excluded?

Re: Background Color in a pie chart

hector_munoz — Fri, 23 Jun 2017 13:14:59 GMT

Hi Matt,

Could you attach a sample? Anyway I would recommend you to create a new table with issue_type field values and their R, G and B components and later use these new fields in the expression in order to simplify it:

Script part:

COLOURS:

LOAD * INLINE [

issue_type, R value, G value, B value

PLandG,252,115,98

GConfig,141,170,203

OnBC,255,217,47

...

];

Design part:

= Rgb(Avg([R value]), Avg([G value]), Avg([B value]))

Regards,
H

Re: Background Color in a pie chart

mparker123 — Fri, 23 Jun 2017 13:25:00 GMT

Unfortunately I can't attach a sample. I also don't know how to enter data in the script the script was designed by someone else in our company so do not want to add to it and potentially mess it up.

Is their a way to do it in the "Background Color" expression using the formula above.

Re: Background Color in a pie chart

avinashelite — Fri, 23 Jun 2017 13:26:08 GMT

Please attach a sample so that it would be helpful for us to understand the issues

Re: Background Color in a pie chart

vishsaggi — Fri, 23 Jun 2017 13:51:52 GMT

Make a copy of your sample qvw file if you dont want to mess the original one. Just rename the copied file and upload here using scrambling technique. Personally i am not very keen in using Pie chart for data display, if i can express the data in a comprehensive way to the user with any other objects ignoring Pie chart, i would do that.

You can scramble data:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Background Color in a pie chart

mparker123 — Fri, 23 Jun 2017 13:56:05 GMT

i attached a sample to my original post

Re: Background Color in a pie chart

ahaahaaha — Fri, 23 Jun 2017 14:07:10 GMT

Hi,

If I understood you correctly, may be as in attached file.

Regards,

Andrey

Re: Background Color in a pie chart

mparker123 — Fri, 23 Jun 2017 14:07:54 GMT

The values in black are the values that should be excluded. As they are excluded in the set analysis

Re: Background Color in a pie chart

mparker123 — Fri, 23 Jun 2017 14:11:54 GMT

Thank You that worked perfectly

Re: Background Color in a pie chart

ahaahaaha — Fri, 23 Jun 2017 14:14:22 GMT

Was glad to help you

Re: Background Color in a pie chart

vishsaggi — Fri, 23 Jun 2017 14:16:14 GMT

Just a small suggestion. Rather than using that long multiple if statements you can try using Pick(Match()) like

= Pick(Match([Issue Type], 'C B', 'CA','CA&R','Con','CR','D','FC','GC','GLR','MDB Config','OBC','OMSC','P','P: P','PL and G','TDMSDandS','TSC'),

RGB(190,108,44),RGB(196,178,214),RGB(166,216,227),RGB(102,194,150),RGB(178,36,36),RGB(0,172,172),RGB(179,179,179),RGB(141,170,203),

RGB(229,182,148),RGB(187,216,84),RGB(255,217,47), RGB(255,191,201),RGB(231,138,210),RGB(77,167,65),RGB(252,115,98),RGB(27,125,156),

RGB(171,233,188)

)

Just replace your if's with Pick(Match())