Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
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
Highlighted
Specialist
Specialist

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

Highlighted
Specialist III
Specialist III

no.. if i select indirect its not working 

Highlighted
Specialist III
Specialist III

Hi  Frank Hartmann    any idea on this? 

Highlighted
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)

Highlighted
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))

Highlighted
Specialist III
Specialist III

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?

Highlighted
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

Highlighted
Master II
Master II

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

Highlighted
Specialist III
Specialist III

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