Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to drill down to a detailed table upon clicking on a pie from Qliksense pie or donut chart?
Thanks
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.
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.
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
@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.
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
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)
Thank you so much!
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