Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

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

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

5 Replies
paulyeo11
Valued Contributor II

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

my qvw

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

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

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

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
Valued Contributor II

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

Hi Sunny & Stan

Thank you very much , it work fine now.

Paul

paulyeo11
Valued Contributor II

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

Hi Sunny

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

Paul

Community Browser