topic Re: Pie Chart Dimension Label in QlikView

Pie Chart Dimension Label

Anonymous — Mon, 27 Apr 2015 17:06:50 GMT

Greetings Experts and Masters,

I have a pie chart with a dimension with two values. See example picture file. I have actually created two pie charts. One that gives a percentage of members in each group and the other give the percentage of dollars spent on each group.

I would like to change the dimension legend labels.

Currently they are CDM Lives and Non CDM Lives

I would like them to be

% with Conditions

% without Conditions

On second chart

% spent with Conditions

% spent without Conditions

I know I could very inefficiently go into the load script and just create some new fields in the table with these new dimension names.

I am hoping for a savvy way of editing legend labels

I also tried creating a calculated dimension, but it shows the formula in the legend rather than the desired labels.

Hope someone has the answer.

Re: Pie Chart Dimension Label

Anonymous — Mon, 27 Apr 2015 17:18:51 GMT

Calculated dimension should work fine, but don't forget to <untick> Label for the Calculated Dimension, otherwise the expression will show as the Label.

Re: Pie Chart Dimension Label

Anonymous — Mon, 27 Apr 2015 17:21:10 GMT

Hi Bill,

Yes, you are correct. I just needed to uncheck the label box and it work. Thanks for your quick response.

Mike

Re: Pie Chart Dimension Label

maxgro — Mon, 27 Apr 2015 17:23:00 GMT

maybe this dimension

=if(Dim='CDM Lives',

dual('% with Conditions', Dim),

dual('% without Conditions', Dim)

)