topic Re: Pie Chart values gets accumulated in QlikView

Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 18:58:14 GMT

Hi,

Im facing an issue with the Data points in Pie chart.

The values are getting accumulated to next Pie area and displaying more than one value in each data point.

Attached is the image..Please help on this to remove the values.

Message was edited by: Anandkumar Kadirvel

Re: Pie Chart values gets accumulated

d_pranskus — Wed, 30 Apr 2014 18:59:38 GMT

Can you send a qvw file sample?

Thanks

Darius

Re: Pie Chart values gets accumulated

its_anandrjs — Wed, 30 Apr 2014 19:00:10 GMT

Can you share your expression or possible sample data for this.

Re: Pie Chart values gets accumulated

MK_QSL — Wed, 30 Apr 2014 19:12:32 GMT

Let us know the Dimensions and Expressions you have used in this PIE CHART.

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 19:18:54 GMT

Sample qvw file atttachedd.

Re: Pie Chart values gets accumulated

MK_QSL — Wed, 30 Apr 2014 19:20:24 GMT

I think you have uploaded wrong qvw...

Re: Pie Chart values gets accumulated

its_anandrjs — Wed, 30 Apr 2014 19:24:01 GMT

In your Expression D click on + and see Pie Popout remove 1 from there and check your Pie chart.

Also your are having 4 expression like

A = 100

B = 200

C = 300

D = 400

the data seems like accumulated and you not use dimension i believe it is due to your expression check once.

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 19:28:02 GMT

@anand chouchan - I have removed the 1 from Pie Popout property but still I am getting the same issue.

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 19:31:07 GMT

I didnt use any dimension becuase the values I need to populate are based on some customized calculations.

U mean the issue occurs because of no dimension?

Re: Pie Chart values gets accumulated

MK_QSL — Wed, 30 Apr 2014 19:31:33 GMT

I still don't understand, where the data get accumulated.???

Re: Pie Chart values gets accumulated

its_anandrjs — Wed, 30 Apr 2014 19:31:56 GMT

Check weather it is in another expression because the file that you provide i am get Pie Popout in only D expression and when i remove it is cleared.

Re: Pie Chart values gets accumulated

its_anandrjs — Wed, 30 Apr 2014 19:32:57 GMT

No due to the expression that is used like it is accumulated

A = 100

B = 200

C = 300

D = 400

Re: Pie Chart values gets accumulated

its_anandrjs — Wed, 30 Apr 2014 19:35:17 GMT

Yes Manish is right actually data is not accumulated the expression is used is four like

A = 100

B = 200

C = 300

D = 400

then the pie is get created data look like accumulated and there is only 4 expressions.

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 21:00:33 GMT

Manish,

The data points in the pie chart is appended one by one to next pie.

U can see in the attachment/

A $100

B $100 $200

C $100 $200 $300

D $100 $200 $300 $400

This should not be the case. It should be like

A $100

B $200

C $300

D $400

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 21:03:06 GMT

You can see the original expressions which are commented in each window of the expressions A, B, C, D

Re: Pie Chart values gets accumulated

MK_QSL — Wed, 30 Apr 2014 21:04:24 GMT

I can't see any accumulation.

This is how your chart on my QlikView...

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 21:09:17 GMT

I dont know how you are getting the chart like that.

You can see my attached image which I am getting with values appended.

Re: Pie Chart values gets accumulated

MK_QSL — Wed, 30 Apr 2014 21:26:39 GMT

Which version you are using?

Re: Pie Chart values gets accumulated

Anonymous — Wed, 30 Apr 2014 22:44:34 GMT

Version 11.00

Re: Pie Chart values gets accumulated

swuehl — Wed, 30 Apr 2014 23:50:42 GMT

Check this post:

Pie chart - Duplicated values on data points