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

[paulyeo11]

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]

my qvw

[sunny_talwar · Accepted solution]

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

[#4]

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]

Hi Sunny & Stan

Thank you very much , it work fine now.

Paul

[paulyeo11]

Hi Sunny

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

Paul