topic Re: Pie Chart visualization: Overlapping values in QlikView

Pie Chart visualization: Overlapping values

Tue, 31 May 2011 11:23:05 GMT

Hi folks,

I have a question regarding pie chart visualization:

The end user wants a pie charts which visualizes his KPI. There are some very high values and some low ones.

Normally, the pie chart is configured, that it creates a virtual dimension "others", where the low values are aggregated. If you click the "others" dimension, then you drill down to the remaining low values.

This is not acceptable for some end users, because they want to export the pie chart to PPT without any drill-down to make.

This is why I changed the minimal value setting for the pie chart to 0.001. This would be the solution, but it leads to overlapping values within the graphic:

Does anyone have a solution to this problem? Is there any option, that the values at the pie chart can be visualized in a staggered way?

I have included a 'demo example' to this problem.

Any help is highly appreciated!

Pie Chart visualization: Overlapping values

prieper — Tue, 31 May 2011 19:59:39 GMT

would a vertical barchart (with sorted dimensions) be a solution?

Peter

Re: Pie Chart visualization: Overlapping values

Tue, 31 May 2011 20:20:14 GMT

Hi Msglanges ,

Can you try to show the values on legend instead of showing them as values on data points .

May be If u can remove the values on data points and select text as pop-up in expression tab and try to select show numbers on legend in presentation tab ...

here is the qwv file ...

Re: Pie Chart visualization: Overlapping values

Tue, 31 May 2011 21:28:27 GMT

Gud idea Brad,

But best way to present this is Bar chart, as Prieper suggested

Re: Pie Chart visualization: Overlapping values

Wed, 01 Jun 2011 12:04:55 GMT

Am Bradd schrieb:
Hi Msglanges ,
Can you try to show the values on legend instead of showing them as values on data points .
May be If u can remove the values on data points and select text as pop-up in expression tab and try to select show numbers on legend in presentation tab ...
here is the qwv file ...

Hi Am Bradd,

I also had this solution in mind, unfortunately the user thinks that it is not as easy to grasp in a management meeting than having the actual values in the graphic.

But thanks anyway, it is a helpful thought!

Re: Pie Chart visualization: Overlapping values

Wed, 01 Jun 2011 12:06:51 GMT

prieper schrieb:
would a vertical barchart (with sorted dimensions) be a solution?
Peter

Unfortunately this is not what the user wants to see... nevertheless, thank you for your input!

Re: Pie Chart visualization: Overlapping values

Wed, 01 Jun 2011 12:49:11 GMT

Hello,

I took sometime and did this. If I was you, this looks a lot better I dont know if its really useful, but Pie charts are used to show percentages rather than the actual numbers.

Thanks

ANDY

Pie Chart visualization: Overlapping values

prieper — Wed, 01 Jun 2011 12:51:41 GMT

In the barchart you may display the percentages as well (choose to show on the axis) or group the expression, one to show the value, the other the percentages.

Peter

Re: Pie Chart visualization: Overlapping values

neetu_singh — Thu, 02 Jun 2011 11:25:35 GMT

Hi,

Please find the attachment. it will help you out.

At expression click on(+)sign and add the expression in Pie popup and in presentation set "lower limit on slice".

As shown in attachment.

Regards

Neetu SIngh

Re: Pie Chart visualization: Overlapping values

stephencredmond — Thu, 02 Jun 2011 12:33:50 GMT

Hi,

You can add some stagger using the Repeat function with some carriage returns. See attached. Note the -6 is a static value which should probably be calculated - I will leave that to you.

However, I agree with the previous comments that suggest that this is a very poor visualisation of the data - use a straight table (where you can have columns for actual amount and %) or a bar chart.

Regards,

Stephen

Re: Pie Chart visualization: Overlapping values

Mon, 06 Jun 2011 07:11:11 GMT

new_user3 schrieb:
Hello,
I took sometime and did this. If I was you, this looks a lot better I dont know if its really useful, but Pie charts are used to show percentages rather than the actual numbers.
Thanks
ANDY

Hi Andy, thanks for the input.

This has the "others" dimension included, which I had to eliminate due to customer requirement.

Re: Pie Chart visualization: Overlapping values

Mon, 06 Jun 2011 07:13:18 GMT

Neetu Singh schrieb:
Hi,
Please find the attachment. it will help you out.
At expression click on(+)sign and add the expression in Pie popup and in presentation set "lower limit on slice".
As shown in attachment.
Regards
Neetu SIngh

I am afraid the end user needs the lower limit setting I used, because the graphic has to be exported to PowerPoint and used during presentations, so any mouse-over effect etc. is not the solution here. But thank you very much!

Re: Pie Chart visualization: Overlapping values

Mon, 06 Jun 2011 07:13:59 GMT

stephen.redmond schrieb:
Hi,
You can add some stagger using the Repeat function with some carriage returns. See attached. Note the -6 is a static value which should probably be calculated - I will leave that to you.
However, I agree with the previous comments that suggest that this is a very poor visualisation of the data - use a straight table (where you can have columns for actual amount and %) or a bar chart.
Regards,
Stephen

The staggering function is exactly what I was looking for! Thank you very much! Made my day!

Re: Pie Chart visualization: Overlapping values

Fri, 30 Mar 2012 14:02:32 GMT

My pie chart doesn't seem to be showing the dimension and the value, like yours.

I'm also using the dual function.

What am I missing?

Re: Pie Chart visualization: Overlapping values

amien — Thu, 08 Nov 2012 08:46:47 GMT

@Beanz ..

Did you found a solution? Example of Stephen is working, but in my own dashboard not. Even tried to copy the object of Stephen, only changed the expression a little bit (different measures)

Re: Pie Chart visualization: Overlapping values

kkkumar82 — Mon, 30 Mar 2015 08:20:10 GMT

does this solution works for combo or two line charts also??

Thanks

Kiran Kumar