topic Drill down between table expressions in QlikView

Drill down between table expressions

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Drill down between table expressions

swuehl — Sun, 21 Aug 2016 21:38:34 GMT

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)

Re: Drill down between table expressions

Sun, 21 Aug 2016 21:42:03 GMT

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

Re: Drill down between table expressions

swuehl — Sun, 21 Aug 2016 21:51:25 GMT

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.

Re: Drill down between table expressions

Sun, 21 Aug 2016 22:25:20 GMT

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

Re: Drill down between table expressions

vishsaggi — Mon, 22 Aug 2016 01:15:28 GMT

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.

Re: Drill down between table expressions

Mon, 22 Aug 2016 10:36:40 GMT

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

Re: Drill down between table expressions

vishsaggi — Mon, 22 Aug 2016 11:53:53 GMT

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 ?

Re: Drill down between table expressions

Mon, 22 Aug 2016 16:05:02 GMT

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

Re: Drill down between table expressions

vishsaggi — Mon, 22 Aug 2016 16:08:47 GMT

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