topic Drill down using inline values in QlikView

Drill down using inline values

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

Good day Community

I have another question.

I have an inline table with values : Category, Department,Chart etc... And I have a pie chart with drill down created, drill down dimensions are: Category, Department, Chart.

how do I make the pie chart drill down based on the inline selection same way it would if I drill down on the chart itself? e.g. If a user selects Department on the inline list, I want the pie chart to also drill down to Department.

Please assist urgently.

Regards

Matlotlo

Re: Drill down using inline values

Anil_Babu_Samineni — Tue, 12 Nov 2019 07:40:40 GMT

What is the measure you are going to use? If it is coming from different fact and dimension tables obviously It doesn't makesense to me since there is no associate as It is island table.

If my understand is wrong, can you re-phrase the question?

Re: Drill down using inline values

nkosinde13 — Tue, 12 Nov 2019 13:49:07 GMT

Thank you @Anil_Babu_Samineni .

That was the problem, that it is an island table. I thought there was a way I could somehow link it to the dimensions being used in the pie charts but that was not the case.

Regards

Matlotlo

Re: Drill down using inline values

Anil_Babu_Samineni — Wed, 13 Nov 2019 06:12:59 GMT

I think you can create ValueList() kind of dimensions that could be hint for you.

Re: Drill down using inline values

nkosinde13 — Wed, 13 Nov 2019 08:03:27 GMT

Thanks for the suggestion @Anil_Babu_Samineni but I'm using the inline table as a list box for conditional show & hide of dimensions for pivot tables and wanted to use the same for pie chart drills. So I cannot have 2 listboxes as these are on the same tab.