topic Selecting values from two tables with one click in QlikView

Selecting values from two tables with one click

Thu, 21 May 2015 12:16:41 GMT

Helo

I've got two independent tables with dates (year + week).

One of them is represented like this:

and finally my question:

is it possible to connect this table to select both fields from two tables?

Tables are made like this:

=mid(FABRIC_CW, 1, 4)

=mid(FABRIC_CW, 5)

and i want to connect it with FABRIC_KW, having the same date format.

Re: Selecting values from two tables with one click

marcus_sommer — Thu, 21 May 2015 13:27:11 GMT

Selecting more than one field by a one-click is only possible per action triggered from origin selection - independent if the fields are associated or not. But I assume you don't need such approach - at first you should look that these tables/fields are connected within the datamodel and then you could use the normal inbuilt association-feature from qv.

- Marcus