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

Now i can zoom in 2 level , How to make it zoom in 3 layer ?

Hi All

I have Table 1 , when i click on the CUST_ID = IU1001 , it will activate Table 2 and Table 3.

I like to know that how to mopdify the script for Table 3 , so that it will not activated , unless i click on Table 2 company or cust_id , then Table 3 will appear ?

meaning when i click oon table 1 cust_id , Table 2 will pop up , and when i click on Table 2 cust_id , Table 3 will pop up.

Hope some one can advise me.

Paul

Paul

1 Solution

Accepted Solutions
Not applicable

Changed the condition on table 3 to use cust_id instead of CUST_ID and this seems to be working, but please check out the attached qvw and see if it is what you are looking for.

- Stan

View solution in original post

10 Replies
paulyeo11
Master
Master
Author

my QVW

Not applicable

Changed the condition on table 3 to use cust_id instead of CUST_ID and this seems to be working, but please check out the attached qvw and see if it is what you are looking for.

- Stan

paulyeo11
Master
Master
Author

Hi Stan

I just check your reply. I found that you are able to make it 3 layer drill in.

Thank you very much for your sharing.

May i know it is possible to have 5 layer drill in ?

Paul

Not applicable

Sure, you should be able to have as many layers as you need.

Do you have an example that you are stuck on?

paulyeo11
Master
Master
Author

Hi Sir

when i click on CUST_ID = T10007

Now all 2 chart and 3 table appear.

My question is how to make it only drill 2 appear and drill 3 4 5 not appear .

and when i click some thing again , i want Drill 3 appear only .

next is when i click on Drill 3 company name , Drill 4 appear. and so on.

Hope some one can advise me.

Paul

Not applicable

I went back to a previous version of your dashboard, but please take a look at the attached version.

Basically each table will display if the selected count on the prior table is 1 and the selected count of the current table is not 1.

paulyeo11
Master
Master
Author

Hi Stan

Thank you very much for your help.

I notice that :-

1st Layer

=GetSelectedCount(CUST_ID)=0

2nd Layer

=GetSelectedCount(CUST_ID)=1 and GetSelectedCount(cust_id)<>1

3th Layer

=GetSelectedCount(cust_id)=1 and GetSelectedCount(company)<>1

May i know if i need the 4th layer , i should use ?

=GetSelectedCount(cust_id)=1 and GetSelectedCount(US_Cust)<>1

it does not work. Can you advise me ?

Paul

Not applicable

For each layer you will have a formula similar to the following:

=GetSelectedCount(DimensionA)=1 and GetSelectedCount(DimensionB)<>1

DimensionA will be the dimension from the previous layer and DimensionB will be from the current layer.

Can you please attach the qvw that is not working?

paulyeo11
Master
Master
Author

Hi All

When with out click on S10010 , i can view layer 1 table

when click on S10010 , i can view layer 2 table

When i click on S10010 , i can view Layer 3 and 4 Table.

My question is how to make it not display layer 4 only 3 on above step.

and when i click on S10010 again then Layer 4 table then appear.

Paul