Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

5 Replies
paulyeo11
Master
Master
Author

my qvw

sunny_talwar

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

Not applicable

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
Master
Master
Author

Hi Sunny & Stan

Thank you very much , it work fine now.

Paul

paulyeo11
Master
Master
Author

Hi Sunny

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

Paul