Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor 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?

Tags (3)
1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor II

Re: two tables

Yes, its possible.

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

Unbenannt.png

9 Replies
vamsee
Valued Contributor

Re: two tables

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

soniasweety
Valued Contributor III

Re: two tables

no.. if i select indirect its not working 

soniasweety
Valued Contributor III

Re: two tables

Hi  Frank Hartmann    any idea on this? 

Frank_Hartmann
Honored Contributor II

Re: two tables

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
Honored Contributor II

Re: two tables

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
Valued Contributor III

Re: two tables

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
Honored Contributor II

Re: two tables

Yes, its possible.

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

Unbenannt.png

Frank_Hartmann
Honored Contributor II

Re: two tables

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

soniasweety
Valued Contributor III

Re: two tables

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