Drill down between table expressions

[#1]

Hi,

I have two tables with below columns , If user clicks on 'Table1'  then another 'Table2' should appear

Table1

Total Number of Orders, Total No of Order Processed, Total No of Orders Cancelled

Table2:

Total No of Items in Order, Sum of Quantity, Order Date

[swuehl]

I assume you are using a dimension in Table1. If the user clicks in a cell in Table1, he is actually making selections in the table dimensions.

Use a show condition (on layout tab in chart properties) in Table2 based on a selection check of Table1 dimensions:

=If(GetSelectedCount( DimensionFieldOfTable1 ) =1 ),1,0)

[#3]

no , there is no dimension in Table1, all are expressions

[swuehl · Accepted solution]

You can use a transparent text box with an action to toggle a variable.

Overlay this transparent text boxes over Table1.

Use this variable in the show condition of Table2.

[#5]

Can you describe the transparent textbox, what does it consist of

[vishsaggi]

Something like this was what Stefan talking about. Check this and try:

In the attached sample if you click on Table 1 Table 2 will show and hide.

Created a variable vShow.

Used text object action item Set variable action - then

vShow

= If(vShow = 0,1,0)

Then in Table 2 Layout Conditional check

= vShow = 1

if this is what you are looking for Mark Stefan' s as Correct as it was his Idea. I have just explained a little thats it.

[#7]

Hi,

I have created transparent text box and placed it over table completely it seems not covering the table , after placing textbox on table  I am not getting the hand click option on table headers and it seems texbox has not covered the table even I have increased the size of textbox and placed it over table

[vishsaggi]

Based on your initial question, you said you want to click on one table1 and table2 should be hidden so, the workaround here was to layover the text box on top of table1, it looks like you are clicking on the table but you are actually clicking on transparent text object. You want to click on table headers or any where in the table. What is your actual requirement can you please elaborate. Could you able to see the attached qvw file ?

[#9]

I set the Layer option of textbox as "Top" and now it is working

[vishsaggi]

Glad it worked. Yes, i my qvw file attached previously has the textobject layer option to TOP.