topic Re: two tables in QlikView

two tables

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

vamsee — Tue, 18 Sep 2018 16:24:09 GMT

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

soniasweety — Tue, 18 Sep 2018 16:49:16 GMT

no.. if i select indirect its not working

soniasweety — Tue, 18 Sep 2018 16:50:55 GMT

Hi Frank Hartmann any idea on this?

Frank_Hartmann — Tue, 18 Sep 2018 17:41:07 GMT

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 — Tue, 18 Sep 2018 18:22:00 GMT

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 — Wed, 19 Sep 2018 04:03:13 GMT

instead of hiding the table

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

Frank_Hartmann — Wed, 19 Sep 2018 05:24:58 GMT

Yes, its possible.

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

Frank_Hartmann — Thu, 20 Sep 2018 10:35:47 GMT

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

soniasweety — Thu, 20 Sep 2018 10:40:07 GMT

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