topic Re: Multiexpression in legend of Pie chart in QlikView

Multiexpression in legend of Pie chart

Thu, 06 Nov 2014 08:43:24 GMT

Hello everyone,

I am trying to make pie chart and kind of creating table to its legends but how to manage those colors corresponds to those colors.

Thnaks in advance

Regards,

Palash Bansal

Re: Multiexpression in legend of Pie chart

danieloberbilli — Thu, 06 Nov 2014 08:58:03 GMT

Chart Properties > tab Colors > set the colors 1-5 on the left according to your desired colorcode. Also check the checkbox 'Persistent Color' to make sure, the colorcode doesnt change with use filters.

Re: Multiexpression in legend of Pie chart

danieloberbilli — Thu, 06 Nov 2014 09:00:32 GMT

and if you would like to set a backgroundcolor to your table dimension (or expression) see dimension (or expression tab) Background color and insert the rgb() codes with an if() clause:

Re: Multiexpression in legend of Pie chart

Thu, 06 Nov 2014 09:04:33 GMT

But how to create table in legends or should I make different table and If I created a different table how to add a collumn of color only instead of giving background color to all of row?

Re: Multiexpression in legend of Pie chart

danieloberbilli — Thu, 06 Nov 2014 09:09:52 GMT

I think you need to solve this with an additional (straight) table. You just a add an empty expression (e.g. with a space character chr(32)) and set the background colors

Re: Multiexpression in legend of Pie chart

Thu, 06 Nov 2014 09:21:26 GMT

And yeah that will work But Do you know how to make that expression collumn (char(32) one) the 1st collumn of the table.

Re: Multiexpression in legend of Pie chart

danieloberbilli — Thu, 06 Nov 2014 09:58:48 GMT

So I guess you have a dimension as first column...you can just drag&drop the expression column in front of (left of) the dimension column

Re: Multiexpression in legend of Pie chart

danieloberbilli — Thu, 06 Nov 2014 10:01:19 GMT