Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
my QVW
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
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
Sure, you should be able to have as many layers as you need.
Do you have an example that you are stuck on?
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
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.
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
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?
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