topic Re: Drilldown from Qliksense Pie / Donut chart in App Development

Drilldown from Qliksense Pie / Donut chart

jpjust — Wed, 11 Aug 2021 15:38:24 GMT

Hi,

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

Thanks

Re: Drilldown from Qliksense Pie / Donut chart

joaopaulo_delco — Wed, 11 Aug 2021 16:47:53 GMT

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.

Re: Drilldown from Qliksense Pie / Donut chart

jpjust — Wed, 11 Aug 2021 18:42:27 GMT

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

Re: Drilldown from Qliksense Pie / Donut chart

joaopaulo_delco — Wed, 11 Aug 2021 19:47:06 GMT

@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.

Re: Drilldown from Qliksense Pie / Donut chart

jpjust — Wed, 11 Aug 2021 20:44:37 GMT

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

Re: Drilldown from Qliksense Pie / Donut chart

joaopaulo_delco — Wed, 11 Aug 2021 20:51:26 GMT

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

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

instead of

sum(expression)

Re: Drilldown from Qliksense Pie / Donut chart

jpjust — Wed, 11 Aug 2021 20:54:37 GMT

Thank you so much!

Re: Drilldown from Qliksense Pie / Donut chart

jpjust — Mon, 16 Aug 2021 16:18:32 GMT

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