Select multiple value in different multiple fields

[alex90qlik]

Hi,

in qlikview when i select two different values from two different fields i obtain an OR logical operation but I want to obtain AND  logical operation.

For example: I  want to obtaint all person who lived in Italy OR travel to Italy by selecting  the corresponding values in two different tables chart.

Is it possible?

Thx

[sunny_talwar]

May be create a link table here

LinkTable:

LOAD Lived_Country as Select_Country,

           Lived_Country,

           'Lived' as [Country Type]

FROM Fact;

Concatenate (LinkTable)

LOAD Travel_Country as Select_Country,

           Travel_Country,

           'Travel' as [Country Type]

FROM Fact;

Now make selections in Select_Country = Italy and it should give you person who either lived in Italy or Traveled to Italy