topic Re: Pie Chart property in QlikView

Pie Chart property

Fri, 04 Jul 2014 10:18:28 GMT

Hello,

My assumption is that, when we click on a legend in a pie chart, it will drill down further to the corresponding set of related data.

However, in the pie chart I created, I am unable to drill down.

Am I missing out on anything?

Thanks.

Re: Pie Chart property

er_mohit — Fri, 04 Jul 2014 10:20:19 GMT

delete that group and again add new drill down group.

if doesn't work please share your sample data

Re: Pie Chart property

Fri, 04 Jul 2014 10:23:34 GMT

My pie chart has no dimensions. It has only three expressions.

Re: Pie Chart property

Fri, 04 Jul 2014 10:44:22 GMT

To be more precise,on clicking a pie slice inside the plot area, i am unable to make selection.

Re: Pie Chart property

kji — Fri, 04 Jul 2014 10:49:19 GMT

Since you don't have a dimension, where do you expect this selection to happen?

Re: Pie Chart property

Fri, 04 Jul 2014 10:51:18 GMT

Hi Sindhu,

You can drill down only on a dimension; not on the expression. You should see if you can add the dimension on which you want to drill down.

Re: Pie Chart property

Fri, 04 Jul 2014 12:00:01 GMT

Hello all,

Balaji, I got it what you are trying to say and now it makes sense why I was unable to select. In the pie chart, All I want to display is the count , which I am able to get now.

e.g:=Sum(Aggr(If(Count(Distinct DEPT_ID) = 0, 1), EMP_ID))

=Sum(Aggr(If(Count(Distinct EMP_ID) = 0, 1), DEPT_ID))

With this , in my pie chart ,I can get the count of all the Employees which do not belong to any Department and all the Departments which do not have a Employee.

However, I would like to see the details of many other dimensions like Purchase, sales etc corresponding to the above value in my other tabs. (Through existing objects)

e.g.details of the Customers , Departments etc which are calculated in the above pie chart.

Re: Pie Chart property

Fri, 04 Jul 2014 12:40:22 GMT

Sindhu,

I believe pie chart is not the best way to represent this information (since we have number of dept and number of employees in the same pie chart - making it incorrect comparison)

Easiest would be to create a straight table with all the fields whose information is needed as dimensions, and retaining the current expressions.

Re: Pie Chart property

Tue, 08 Jul 2014 05:42:39 GMT

Thks Balaji and others for your inputs.