Colors in diagrams and legend in QlikView

[Anonymous]

Hello dear forum members,

I have a little problem with the colors in Qlikview :

In a pie chart, a segment is shown in white, but instead of that black in the legend. The color palette does not display either color. I've attached a picture. How can I change the behavior? My QlikView version is 12.10.20600.0 SR8.

Many Thanks.

[PrashantSangle]

can you share working file??

Regards,

[Anonymous]

Hi Prashant,

I have attached a working file.

Regards

Rolf

[marcus_sommer]

How is the color defined - really with white() or rgb(255,255,255)? Or it's different with something like argb(0,0,0,0)?

- Marcus

[PrashantSangle · Accepted solution]

Hi,

This is because of background expression you have written for expression.

add color for value 'ZE' in your pick function

=pick(match(RKT_AE_Grund,'HD','ND','OPS','Beatmung','VWD','ZE'),Color(1),Color(2),Color(3),Color(4),Color(5),Color(6))

Regards,

[Anonymous]

Hi Prashant,

many thanks for your anwser.  Now everything is clear to me. But I have to remark, that I didn't wrote the pick statement by myself. It was generated by qlikview itself.

After a while I changed the loadscript to add a new category to the Dimension being aware neither of the "fixed" category list in the pick Statement nor the pick Statement at all.

Again many thanks.

Rolf

[Anonymous]

Hi Marcus,

Prashant solved the Problem. It seems that QlikView generates a pick Statement by itself under certain conditions. I'll try to reproduce that.

Regards

Rolf

[PrashantSangle]

I did not get your point. I never saw pick statement generated by QlikView.

Is there anything which I am missing..

Regards,

[Anonymous]

Hi Prashant,

I was not aware that this expression existed and I am currently the only one that developes this file so, yes, it seems that the pick Statement was generated. I'll try to reproduce it and will than come back with more Information.

Again, thanks for your help.

Rolf