topic Re: Pie Chart in QlikView

Pie Chart

krishna20 — Wed, 18 Mar 2015 11:42:32 GMT

Hi Friends,

I'm having pie chart showing the values in percentage. When i click on particular region it needs to show the actual ratio value not 100% . How can we set the property for this. Can anyone please suggest me.

Regards

Krishna

Re: Pie Chart

Gysbert_Wassenaar — Wed, 18 Mar 2015 12:18:45 GMT

If you have the option Relative enabled for the expression then disable it. Use an expression like sum(Amount)/sum(all Amount)

Re: Pie Chart

Wed, 18 Mar 2015 13:09:59 GMT

hi krishna20

Can you attach your sample data ?

Re: Pie Chart

MK_QSL — Wed, 18 Mar 2015 13:16:15 GMT

Consider that you have below data

Load * Inline

[

Customer, Sales

A, 100

B, 400

C, 500

];

Pie chart is

Dimension

Customer

Expression

SUM(Sales)

Untick Relative checkbox and use as below expresion

SUM(Sales)/SUM({<Customer = >}TOTAL Sales)

Re: Pie Chart

Wed, 18 Mar 2015 13:23:44 GMT

How did you get the percents behind the regions?

If I by notation press on: show in percent (%), it is not correct.

F/e if the number is 1875 than gives he 1875% and that is incorrect.

Who could help me?

Re: Pie Chart

krishna20 — Thu, 19 Mar 2015 06:03:19 GMT

Hi,

Please find the attached qvw. In this app they have mentioned in the Ratio Tab.we can show actual ratios by using Legend. Can you please suggest me how can we solve this? !!

Regards

Krishna

Re: Pie Chart

MK_QSL — Thu, 19 Mar 2015 07:25:45 GMT

Change the expression as below

SUM({<Year={$(=Max(Year)), $(=Max(Year)-1)}>}Sales)/SUM({<Region =, Year={$(=Max(Year)), $(=Max(Year)-1)} >}TOTAL Sales)

Re: Pie Chart

krishna20 — Thu, 19 Mar 2015 08:06:52 GMT

Hi ,

I'm getting similar values after using TOTAL in the expression. Please find the attached Images before and after.Please suggest me any other way.

Regards

Krishna

Re: Pie Chart

MK_QSL — Thu, 19 Mar 2015 08:10:48 GMT

From Where you get Number Of Loss in that Chart?

Also, let me know the expression and dimension you have used..

Re: Pie Chart

krishna20 — Thu, 19 Mar 2015 08:18:06 GMT

Hi,

Nature of Loss is a dimension for the pie chart and the expression is

=Sum({<EST_TYPE = {1}>} AMT_LC_1)

-Sum({<EST_TYPE = {3}>} AMT_LC_1)

-Sum({<EST_TYPE = {2}>} AMT_LC_1)

+Sum({<EST_TYPE = {4}>} AMT_LC_1)

Regards

Krishna

Re: Pie Chart

hariprasadqv — Thu, 19 Mar 2015 08:29:23 GMT

Disable relative property if you are using it.

Re: Pie Chart

krishna20 — Thu, 19 Mar 2015 08:42:08 GMT

Hi,

In this chart I'm grouping two expressions ,one for total amount and another for the percentage .If i disable the relative cyclic group not working.

Regards

Krishna