topic Re: List boxes that filter fields on two different tables. in QlikView

List boxes that filter fields on two different tables.

Wed, 25 Nov 2020 16:16:04 GMT

I have two tables with the same field in both. I would like to have one list box that filters both these fields. For example:

Table1:

Process

Risk

Control

Table2:

Process

Tester

Test Manager

I would like to have one list box with 'process' that filters both tables. Is this possible?

Re: List boxes that filter fields on two different tables.

saumyashah90 — Thu, 27 Apr 2017 15:06:37 GMT

are they two different tables with no join?

By Default Process will get associated with both the tables.You can check typing Ctrl+t

Re: List boxes that filter fields on two different tables.

vishsaggi — Thu, 27 Apr 2017 15:12:35 GMT

Two tables will join if they have atlease one Fieldname common. So when you load these two tables, you should have only one FieldNamed Process which you can use as Listbox.

Re: List boxes that filter fields on two different tables.

awhitfield — Thu, 27 Apr 2017 15:23:48 GMT

Hi Jessica,

that's the default behaviour in QV. Have you got some sort of issue with it? They will be linked by process.

Andy

Re: List boxes that filter fields on two different tables.

Thu, 27 Apr 2017 15:51:56 GMT

Hi there Jessica,

Yes, here you go. Data used is imaginary for demonstration purposes.

Step 1 - load your tables and check table viewer

Step 2 - add a list box for Process and a table box to show rest of the fields/values

Step 3 - select a value in Process list box to filter both tables, see below.

I hope this helps you.

Warm regards,

Nish