Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

drill down 3 different tables

Hi QV

My requirement is I have 3 tables with difference dims and different expression for each dim.

Let say

table1:

DIm1 Sum(Expr)

A

B

C

Table2:

Dim2  sum(Expr)

x

y

If  I select Dim1 field values(A,B,C) in table1, I need to display table2 with associate values and table1 should be replacing with table2.Same logic for table 3 also(If I select any value in table2 I need to display table3 associate values for each dim2).

Yes I know we need to use group dimention drilldown but I need some sample app to implement it..

if any one have sample qvws share me here.

Thanks

5 Replies
qlikoqlik
Creator
Creator

Hi Swathi

Do you have a licensed version of Qlikview to open the Qvws done on personal edition

Thanks

Padma

sudeepkm
Specialist III
Specialist III

can you please explain how your tables are associated. pls provide sample data.

Not applicable
Author

yes I have ...pls post here.

thanku

stabben23
Partner - Master
Partner - Master

Hi,

try like this:

in table 2 in Layout-->Show-->Conditional: =getselectedcount(Dim1)>=1

in table 3 in layout-->Show-->Conditional: =getselectedcount(Dim2)>=1

Not applicable
Author

Thanks Johansson that should be fine.....but I want to display associate table only.

if we select any value in table1 ..table1 will hide and table 2 will display.

if we select any value in table2 ..table2 will hide and table 3 will display.

Finally I need to drill up like table3-->table2-->table1

thanks