topic Re: Drill in by click on cust_id For hide main table and display sub table. in QlikView

Drill in by click on cust_id For hide main table and display sub table.

paulyeo11 — Wed, 14 Sep 2016 02:19:55 GMT

Hi All

I like to let the user click on Table one Cust_ID , and it will make Table 2 appear.

Table 1 Layout condition i set as below :-

=if(GetSelectedCount(CUST_ID)=1,0,1)

Table 2 Layout condition i set as below :-

=if(GetSelectedCount( cust_id_ar) =1,1,0)

But it does not work.

Hope some one can help me.

Paul

paulyeo11 — Wed, 14 Sep 2016 02:20:40 GMT

my qvw

sunny_talwar — Wed, 14 Sep 2016 02:23:02 GMT

Table1 needs to go away when you select one Cust_ID? If yes, then try these

Table1 condition

=GetSelectedCount(CUST_ID) = 0

Table2 condition

=GetSelectedCount(CUST_ID) = 1

Wed, 14 Sep 2016 02:38:47 GMT

Give the attached qvw a try which is using the following formulas:

Table 1 Layout condition:-

=if(GetSelectedCount(CUST_ID)=1,0,-1)

Table 2 Layout condition:-

=if(GetSelectedCount(CUST_ID)=1,-1,0)

I believe -1 is actually true and not 1.

This should do the trick!

- Stan

paulyeo11 — Wed, 14 Sep 2016 03:00:33 GMT

Hi Sunny & Stan

Thank you very much , it work fine now.

Paul

paulyeo11 — Wed, 14 Sep 2016 03:23:50 GMT

Hi Sunny

I just notice that you code is very simple, don't need 1,0,1 ...

Paul