topic Re: Alternate slices in pie chart in QlikView

Alternate slices in pie chart

Thu, 12 Sep 2013 13:39:08 GMT

Hi, this is a tricky one, not sure if anyone can assist. I have a pie chart and I need to place the values on the chart. When there are 2 or more thin slices next to one another, the text overlaps. There is a good post on how to stagger the text which is great but the client does not want this. Also, he wants a pie chart and not a bar chart which is unfortunate but what can you do... One way of ensuring the text does not overlap is to alternate the slices - thin/thick/thin/thick. Is there any clever way of doing this in QV?

Thanks very much.

Re: Alternate slices in pie chart

Thu, 12 Sep 2013 13:48:56 GMT

I happened upon your post - I don't know the direct answer to your question, but I believe there is an extension which is a pie chart with lines leading out to the values. I'd look it up for you but I'm a bit pressed for time - it may be worth investigating and I'll take a look myself a little later if I get the time. Sorry I could not have been of more direct help.

Steve

Re: Alternate slices in pie chart

Thu, 12 Sep 2013 15:56:19 GMT

Thanks Steve! I think you might be onto something. Its a v11 feature right? Time to upgrade. WIll check this out and let you know.

Re: Alternate slices in pie chart

Gysbert_Wassenaar — Thu, 12 Sep 2013 16:25:49 GMT

It's part of the example extensions from QlikTech. It should be installed in the examples directory: <...YourQVInstallationDirectory...>\Examples\Extensions\Extension Examples.qar

Note, the extension will only work in WebView and in the ajax client.

Re: Alternate slices in pie chart

swuehl — Thu, 12 Sep 2013 16:36:42 GMT

If you want to use a QV only solution, you can try to sort your chart dimension like

Largest, Smallest, 2nd largest, 2nd smallest, 3rd largest, 3rd smallest ...

Maybe using a sort expression in your chart like

=rank(count(Value))*(rank(-count(Value))-0.5)

Re: Alternate slices in pie chart

Fri, 13 Sep 2013 10:56:46 GMT

Thanks for feedback - this approach moves the slices around so I'll tinker with that. Cheers!

Re: Alternate slices in pie chart

mountaindude — Mon, 16 Dec 2013 21:47:54 GMT

Gysbert,

Is the labeled pie chart really included in the standard QV installation these days?

I am running latest QV11 SR4, and the extensions I get as part of QV desktop, when installing the Extension Examples.qar are:

bullet

calendar

geoHeat

org

WebPageViewer

Are others seeing this too? Or am I missing something?