topic Pie Chart View Problem in QlikView

Pie Chart View Problem

its_anandrjs — Mon, 08 Aug 2011 12:45:33 GMT

Hi All,

I have a pie chart problem on that i have a field that conatains 36 values of that corresponding a sum values are there and want to build pie chart when i created it.

1. It is not properly viewable

2. and all legends is not viewble on whole chart

Is there any way to do this thing

Any one provide help for the Pie Chart please.

Anand

Pie Chart View Problem

Mon, 08 Aug 2011 13:38:01 GMT

Hi Anand ,

Can you specify that what do you mean by not properly viewable means . If possible give me some sample data / a image of your issue

thank you

Meher .

Pie Chart View Problem

villafuerte — Mon, 08 Aug 2011 14:05:08 GMT

Maybe this can help:

If you press and hold Ctrl + Shift some red lines appear, now you can move the legends and all other elements in the chart.

Also, it is possible that not all 36 values are shown in the pie. You can go to Properties > Presentation and limit the smallest area visible, the number of slices and so on.

If the chart is not displayed at all, maybe you can try filtering only positive values.

If you have a dummy file it could be useful!

Re: Pie Chart View Problem

its_anandrjs — Mon, 08 Aug 2011 14:05:23 GMT

Hi Merwan,

I attached a sample file please see it only few increase of width and height of chart is able to change it is a condition. On the chart you see in legend section a Others row is created when i click on that remaining five is display but i dont want that it should display all values at once. All the 36 values should dislpay at a time.

Please provide help for that.

Regards,

Anand

Pie Chart View Problem

its_anandrjs — Mon, 08 Aug 2011 14:11:24 GMT

Hi Villafuerte,

It is a condition that we have to display 36 values at a time, also i do that you suggest me but not works and i limit the ares upto 0.001. but you see the chart how it display.

Regards,

Anand

Re: Pie Chart View Problem

Mon, 08 Aug 2011 14:19:29 GMT

Hi,

If you look at the presentation properties, you can see the lower limit on slice area is set as "0.001" - this is the default lower limit - this cannot be changed. This will make those pie slices which are below this value to be a single "Others" - this is what is happening in your case. I don't think we can do anything for this issue.

Val32	214	0.0009
Val08	159	0.0007
Val20	158	0.0007
Val13	147	0.0006
Val04	126	0.0006

Hope this clears the doubt.

Re: Pie Chart View Problem

villafuerte — Mon, 08 Aug 2011 14:21:26 GMT

Indeed, your data is smaller than QlikView's limit... I know this may be a business rule, but you can try using other type of chart.. a Bar chart with scroll should work fine...

Re: Pie Chart View Problem

its_anandrjs — Mon, 08 Aug 2011 14:29:38 GMT

Hi All,

Thanks to reply and give suggestions, Sajeevan i want to know the lower limits of values provide details for that which is in Bold case.

Val32	214	0.0009
Val08	159	0.0007
Val20	158	0.0007
Val13	147	0.0006
Val04	126	0.0006

Regards,

Anand