Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 .
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!
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
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
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.
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...
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