topic Re: How To Prevent Pie Chart From Resizing? in QlikView

How To Prevent Pie Chart From Resizing?

Sat, 22 Jun 2013 02:16:45 GMT

In the attached example, I've got two pie charts, one of which changes sizes based on data. Infuriatingly, I cannot find any way to control it.

This is a reduced data set which has been anonymized, then moved to Excel for easy transport in order to demonstrate the issue.

I created the second pie chart in this example by cloning the first one and then editing the expressions and titles.

I have played with resizing the little red boxes under Ctrl-Shift.
I have played with Fast Change in an effort to exert more control over red boxes.
I have also attempted to use Fast Change in an effort to exert control over the othewise missing Axes tab on Pie Charts.
I have played with Lower Limit on Slice Area.
I have tried Reset User Sizing.
I have tried Reset User Docking.
I have tried just about everything I can think of and this pie has a mind of its own.

I am constrained more or less to the sizes in the example; the rest of the tab is loaded with other stuff. There is some leeway within the boundaries of the text box, but I must think (or at least live) inside the box on this one.

When Division ABC is selected, both pies are the same size.

When XYZ is selected, or if neither Division is selected, the upper pie shrinks.

If I throw smaller data at it (all numbers reduced by three orders of magnitude, for example), the pies remain a steady size. So it has to do with the data ranges, I suspect.

Just shy of 63 million options in Qlikview and not a single "Leave it where I put it" checkbox. (LOL)

But why can't I lock this thing down? What am I doing wrong? How do I fix it? Why is the sky blue? Aiaiaiaiirrrgh!!!!

Any thoughts?

Re: How To Prevent Pie Chart From Resizing?

Gysbert_Wassenaar — Sat, 22 Jun 2013 08:53:38 GMT

This happens because you display values in the pie chart. The pie chart changes size to make room for the labels. Maybe a bar chart works better. See attached example.

Re: How To Prevent Pie Chart From Resizing?

Mon, 24 Jun 2013 16:25:03 GMT

Thank you for the information.

The pie chart is a hard requirement, so the bar chart, while solving the resize problem, does not work better in this context.

The data display on the chart was the change being requested and is responsible for the activity, so that's what I'll take back to the user.

Since I was looking, essentially, for an override to this automatic resizing, and none was suggested, I will take it as presumed there is no such override. 😞

Thanks again for the information and analysis.

- Steve M.