Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

two tables

Hi all,

i have two tables  and one listbox called route

and  table1 and table2  

my rquirment is  user select  Direct   table1 should appear and user select indirect table2 should appear

how can i do this?

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Yes, its possible.

Use the calculated condition in General Tab as well as the custom Errormessage on the bottom:

Unbenannt.png

View solution in original post

9 Replies
vamsee
Specialist
Specialist

You can do this in the Layout tab under properties of a chart.

soniasweety
Master
Master
Author

no.. if i select indirect its not working 

soniasweety
Master
Master
Author

Hi  Frank Hartmann    any idea on this? 

Frank_Hartmann
Master II
Master II

go to table 1 Layout Tab --> show Conditional:

If(GetFieldSelections(route)='Direct',1,0)

go to table 2 Layout Tab --> show Conditional:

If(GetFieldSelections(route)='Indirect',1,0)

Frank_Hartmann
Master II
Master II

But if both tables should be visible when both field are selected at the same time then use these formulas instead:

Table 1: If(GetFieldSelections(route)='Direct, Indirect',1,If(GetFieldSelections(route)='Direct',1,0))

Table 2: If(GetFieldSelections(route)='Direct, Indirect',1,If(GetFieldSelections(route)='Indirect',1,0))

soniasweety
Master
Master
Author

instead of hiding the table 

franky_h79

if i want to show error message  like please select route to show the chart    is this possible?

Frank_Hartmann
Master II
Master II

Yes, its possible.

Use the calculated condition in General Tab as well as the custom Errormessage on the bottom:

Unbenannt.png

Frank_Hartmann
Master II
Master II

What else do you expect to get a correct answer instead a helpful one?

soniasweety
Master
Master
Author

sorry for delay in correcting the answers as i need to test with original app then i can close