Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor

Pie Chart Dimension Label

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.

1 Solution

Accepted Solutions
Highlighted

Re: Pie Chart Dimension Label

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

View solution in original post

3 Replies
Highlighted

Re: Pie Chart Dimension Label

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

View solution in original post

Highlighted
Valued Contributor

Re: Pie Chart Dimension Label


Hi Bill,

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

Mike

Highlighted
MVP
MVP

Re: Pie Chart Dimension Label

maybe this dimension

=if(Dim='CDM Lives',

dual('% with Conditions', Dim),

dual('% without Conditions', Dim)

)

1.png