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

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

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

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

10 Replies
paulyeo11
Valued Contributor II

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

my QVW

Not applicable

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

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

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

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

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

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

Do you have an example that you are stuck on?

paulyeo11
Valued Contributor II

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

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

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

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

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

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

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

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

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

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

Community Browser