Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Multiexpression in legend of Pie chart

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.

piechart.PNG.png

Thnaks in advance

Regards,

Palash Bansal

7 Replies
danieloberbilli
Valued Contributor II

Re: Multiexpression in legend of Pie chart

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.

danieloberbilli
Valued Contributor II

Re: Multiexpression in legend of Pie chart

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:

Not applicable

Re: Multiexpression in legend of Pie chart

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?

danieloberbilli
Valued Contributor II

Re: Multiexpression in legend of Pie chart

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

Not applicable

Re: Multiexpression in legend of Pie chart

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

danieloberbilli
Valued Contributor II

Re: Multiexpression in legend of Pie chart

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

danieloberbilli
Valued Contributor II

Re: Multiexpression in legend of Pie chart

Community Browser