Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nkosinde13
Contributor

Drill down using inline values

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

1 Solution

Accepted Solutions

Re: Drill down using inline values

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies

Re: Drill down using inline values

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

nkosinde13
Contributor

Re: Drill down using inline values

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nkosinde13
Contributor

Re: Drill down using inline values

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.