Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
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.
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 ?
Sure, you should be able to have as many layers as you need.
Do you have an example that you are stuck on?
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.
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.
Thank you very much for your help.
I notice that :-
=GetSelectedCount(CUST_ID)=1 and GetSelectedCount(cust_id)<>1
=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 ?
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?
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.