topic Re: Pie Chart in QlikView

Pie Chart

Fri, 27 Mar 2015 16:22:56 GMT

Hello everyone,

pie chart.... between the values that I represent, there are positive and negative values then the graph does not appear for the presence of negative values.

If I have many clients I bypassed the problem by showing the first 15 customers and the rest as other ... at this point the negative value is absorbed and the graph appears.

The problem is when I have a number of customers poor and I can not handle a customer as part of Other.

Can I exclude from the pie chart, the negative value ... if you possible ... how?

Thanks to all in advance.

Gian Paolo

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 16:32:46 GMT

You should be able to modify this expression to your needs, by changing FieldOne to your Dimension and FieldThree to your Fact :

Sum(Aggr(If(Sum(FieldOne)>0,Sum(FieldOne)),FieldThree))

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 16:35:36 GMT

You certainly can, as bill.markham pointed out. The question is - maybe pie chart is not the right choice. I recommend bar chart.

Re: Pie Chart

Fri, 27 Mar 2015 16:42:49 GMT

Thanks for the reply ... but I did not understand ... you please be a little more specific?

Thanks

Gian Paolo

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 16:44:32 GMT

For your Pie Chart could you paste the Dimension and Expression in here and I'll slot them into my expression for you.

Re: Pie Chart

Fri, 27 Mar 2015 16:46:53 GMT

Hi Michael

the general management wants pie .....

Thanks

Gian Paolo

Re: Pie Chart

Fri, 27 Mar 2015 16:51:30 GMT

Hi Bill

I can send you the application masked?

Please?

Thanks

G P

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 16:51:50 GMT

Ask them how a negative slice of pizza should look like . You can either not show them as Bill suggests, or show as positive - in both cases it distorts information.

Pies are overrated

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 16:52:02 GMT

That will do nicely.

Re: Pie Chart

pokassov — Fri, 27 Mar 2015 17:03:11 GMT

Hi, Gian!

You can change your expression by this way:

nummax(0,sum(FV_Imponibile))

In this case your negative values will be omited

Re: Pie Chart

Anonymous — Fri, 27 Mar 2015 17:21:37 GMT

Sum(Aggr(If(Sum(FV_Imponibile)>0,Sum(FV_Imponibile)), $(=GetCurrentField( _Cliente)) ))

Although the suggestion from pokassov looks more elegant.

Do take note of the comments by msolomovthat a Bar Chart could be better than a Pie Chart. There is a great book by Stephen Few called Information Dashboard Design which explains pro's & con's of various visualizations that I would highly recommend.