topic Re: Reposition Pie Chart data point values? in QlikView

Reposition Pie Chart data point values?

Tue, 04 Mar 2014 20:31:15 GMT

Hi community,

How do we reposition a Pie Chart data point value so that they are more readable?

In the example below, it is hard to read the data values on the blue and red slices. I want to reposition the numbers and not just decrease the font.

Thanks!

Re: Reposition Pie Chart data point values?

Anonymous — Tue, 04 Mar 2014 20:39:33 GMT

We can't.

You have space on the right - can use "show numbers in legend".

Re: Reposition Pie Chart data point values?

rustyfishbones — Tue, 04 Mar 2014 20:40:24 GMT

You can try pressing CTRL + SHIFT and re positioning the chart

or maybe show the numbers in the legend

Go to presentation tab in the Chart Properties and tick Show Numbers in Legend.

It is a better alternative

result will be like below

However, I would only advise you use a Pie Chart when you are comparing 2 or 3 Values

Re: Reposition Pie Chart data point values?

Carlos_Reyes — Tue, 04 Mar 2014 20:41:11 GMT

The only alternative is to check " Show numbers in Legend " in the Presentation tab (Object Properties.) and show numbers in legend not in the near the slices.

For "Values on Data Points", and as far as I know, there is no QlikView option to reposition this values in the chart.

Re: Reposition Pie Chart data point values?

veidlburkhard — Tue, 04 Mar 2014 20:47:01 GMT

Hi Irene,

try this: limit your dimension to 5 and add a second expression for the labels to place below the values. Uncheck 'Show legend' in the 'Presentation' tab. See the picture below:

Re: Reposition Pie Chart data point values?

Tue, 04 Mar 2014 20:55:19 GMT

Hi Burkhard,

How do I add a second expression for the labels to place below the values?

Thank you.

Re: Reposition Pie Chart data point values?

veidlburkhard — Tue, 04 Mar 2014 21:12:37 GMT

Hi Irene,

go to the 'Expression' tab, click on add and key it in:

Re: Reposition Pie Chart data point values?

jonasheisterkam — Tue, 04 Mar 2014 21:23:43 GMT

Hi,

if you have a web connection you can use web-services like Google Chart Tools (Image Charts).

Re: Reposition Pie Chart data point values?

veidlburkhard — Tue, 04 Mar 2014 21:29:33 GMT

...there is also a solution with one expression only. The label and values start to add more and more distance to the pie so standard overlapping values are clearly visible then. See below the picture!

Two remarks:

i) the parameter of the rank function in my example '5' gives you the starting point for distant placement of the lables and values. You can adjust it to your application.

ii) Please make always sure with the dual function to mark the 'Expression default' check box of the 'Number' tab. Otherwise it will not work.

Enjoy.

Re: Reposition Pie Chart data point values?

Anonymous — Tue, 04 Mar 2014 21:43:16 GMT

I have used google charts for pie and venn diagrams too just because of this issue. they work great!

Re: Reposition Pie Chart data point values?

Christian_Lauritzen — Tue, 04 Mar 2014 22:47:50 GMT

Nice! You could actually skip chr(13) and only keep chr(10) for the same result.

Re: Reposition Pie Chart data point values?

kkkumar82 — Wed, 28 Jan 2015 09:12:07 GMT

can you give some steps how to use google charts in qlikview app like

how to pass the dimension, measures etc.

Thanks

Re: Reposition Pie Chart data point values?

kkkumar82 — Wed, 28 Jan 2015 09:12:19 GMT

can you give some steps how to use google charts in qlikview app like

how to pass the dimension, measures etc.

Thanks

Re: Reposition Pie Chart data point values?

Anonymous — Mon, 02 Feb 2015 16:15:04 GMT

Check out this extension (http://branch.qlik.com/projects/showthread.php?299-Google-Pie-Chart-extension)