Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Select multiple value in different multiple fields

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

1 Reply
Highlighted

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