topic Re: Regarding Pie Chart zero values in QlikView

Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:26:15 GMT

Hello There,

I have this situation and my dataset looks something like this.

Bucket Amount_Due

Current 1000

31-60 Days 2000

61-90 Days 1500

91-120 Days 0

121-150 Days 0

151-180 Days 1200

181 Days and Over 5000

So I am trying to build a pie chart, but because the bucket with 91-120 Days and 121-150 Days doesn't have any values so the legend doesn't show these values. So in the legend it looks something like this...

Can you please suggest how can I put all the values of the field in the legend and in the pie chart may be i can show them as zero %.

Thanks.

Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:29:50 GMT

Right click pie chart > Properties > Presentation > uncheck suppress zero and suppress missing boxes

Should do the trick.

Thanks

Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:38:52 GMT

I take it back. This usually works for tables, bar charts,etc.. but when I tried for Pie it didn't, but then it occurred to me that in a pie you can't show zero values. The circle is split into different pies based on the positive non-zero values only.

Thats the whole concept for using Pie.

Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:40:23 GMT

Btw i tried...and it is working fine...thanks for the answer...

yours might be something other issue...

Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:47:50 GMT

Really? Thats quite interesting. Now you have got me thinking. Can you post a snapshot(pic) of the pie. Just curious to see how it looks if you dont mind.

Re: Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:52:31 GMT

It looks like this now....

Re: Regarding Pie Chart zero values

Wed, 26 Feb 2014 22:56:42 GMT

Glad its working for you.

I tried in QV 10 SR 6 and it didn't.