Drilldown from Qliksense Pie / Donut chart

[jpjust]

Hi,

Is it possible to drill down to a detailed table upon clicking on a pie from Qliksense pie or donut chart?

Thanks

[joaopaulo_delco · Accepted solution]

Hi @jpjust !

    It's perfectly possible. But you have to do it using containers.

You have to put the Pie Chart and the Table inside the container and configure the condition to the tab's apear.

Condition to pie chart tab: GetSelectedCount(Dim1)=0

Condition to table tab: =GetSelectedCount(Dim1)>0

Look at the app attached to see the example.

[jpjust]

Thanks so much!

Is there a way to keep the pie chart also on the container while the table displays the details of the pie?

Thanks

[joaopaulo_delco]

@jpjustunfortunately it's not possible to distplay more than 1 object inside a tab of a container. Just 1 object per tab.

Please mark the post as solved if the tip has solved your problem.

[jpjust]

One last question to see if it is possible.

Lets consider the table as below. The pie is sliced on Dim1, so when I select A from the Pie, the table should display only Dim1 that has Dim2 as Pro.

Dim1             Dim2                        sum(expression)

A                     Pro                                    123456

A                   Analyzer                            45678

B                 Analyzer                             565677

B                 Analyzer                             565677

[joaopaulo_delco]

In this case, you should put the follow expression on yout table object measure.

Sum({<Dim2={'Pro'}> expression} 

Sum({<Dim2={'Pro'}> expression}

instead of 

sum(expression)

[jpjust]

Thank you so much!

[jpjust]

Hi,  Not sure if it is possible, so thought to ask you.

I have 2 pie charts in the container. I am  doing an drill down from one pie chart to an table.

Now I want to do an drill down from the second pie char to different table on the same container.

I was checking around on the container properties and don't see an option.

Is there an way that you know of may be writing an expression on Show condition to some how reference to second table, please let me know.

Thanks