topic Re: Pie chart - Include boundary values in QlikView

Pie chart - Include boundary values

Fri, 18 Apr 2014 01:25:23 GMT

What is that option for ?

Select the Show only values that accumulate to radio button and set the corresponding value to 50% relative to the total. Enable the Include Boundary Values checkbox as well.

Re: Pie chart - Include boundary values

Fri, 18 Apr 2014 02:07:06 GMT

where you get this options can you post snipping shot images, so i will try to help you.

Thanks & regards

Venu

Re: Pie chart - Include boundary values

Fri, 18 Apr 2014 03:03:45 GMT

Show only values that accumulate to:

When this option is selected,all rows up to the current row are accumulated, and the result is

compared to the value set in the option. The relative to the total option enables a relative

mode which is similar to the Relative option on the Expressions tab of the property dialog,

and compares the accumulated values (based on first, largest or smallest values) to the overall

total. The value may be entered as a calculated formula. Click on the ... button to open the

Edit Expression Dialog . Select Include Boundary Values to include the dimension

value that contains the comparison value.

Note!

Negative values will not be included when calculating the accumulated restriction sum. We

recommend that you don't use relative restrictions for fields that can contain negative values.

Re: Pie chart - Include boundary values

Fri, 18 Apr 2014 20:06:00 GMT

image here -

Re: Pie chart - Include boundary values

Anonymous — Fri, 18 Apr 2014 20:32:48 GMT

Pie charts are evil

And using pie charts with dimension limit makes them worse

Well, if you don't use this check box, you get the set of slices which in the "non-limited" version took just under 50%. If you check the box, you add the next largest slice.

(It makes little sense to me to use pie chart in this way)

Edit: in case of the pie chart, do not uncheck "show others".

Re: Pie chart - Include boundary values

cfz — Fri, 18 Apr 2014 20:39:54 GMT

Hi John,

Look at the two pie charts in the attached QlikView document.

Both show values that accumulate to 80%.

In the first one the Include Boundary Values option is checked and the result is that the values shown accumulate to 90%.

In the second one one the Include Boundary Values option is not checked and the result is that the values shown accumulate to 70%.

I hope it helps.

Carlos

Re: Pie chart - Include boundary values

Fri, 18 Apr 2014 21:53:17 GMT

I am still not able to see the % symbol.