Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill down between table expressions

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

1 Solution

Accepted Solutions
MVP
MVP

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.

View solution in original post

9 Replies
MVP
MVP

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)

Not applicable

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

MVP
MVP

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.

View solution in original post

Not applicable

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

Champion III
Champion III

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.

Not applicable

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

Champion III
Champion III

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 ?

Not applicable

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

Champion III
Champion III

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