Select multiple value in different multiple fields

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

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

Re: Select multiple value in different multiple fields

sunny_talwar — Wed, 29 Mar 2017 15:40:43 GMT

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

topic Select multiple value in different multiple fields in QlikView

Select multiple value in different multiple fields

Re: Select multiple value in different multiple fields