topic Re: drill down 3 different tables in QlikView

drill down 3 different tables

Wed, 13 Aug 2014 11:11:36 GMT

Hi QV

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

Let say

table1:

DIm1 Sum(Expr)

Table2:

Dim2 sum(Expr)

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

Re: drill down 3 different tables

qlikoqlik — Wed, 13 Aug 2014 11:54:53 GMT

Hi Swathi

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

Thanks

Padma

Re: drill down 3 different tables

sudeepkm — Wed, 13 Aug 2014 11:59:51 GMT

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

Re: drill down 3 different tables

Wed, 13 Aug 2014 12:09:53 GMT

yes I have ...pls post here.

thanku

Re: drill down 3 different tables

stabben23 — Wed, 13 Aug 2014 12:12:19 GMT

Hi,

try like this:

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

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

Re: drill down 3 different tables

Wed, 13 Aug 2014 14:13:13 GMT

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