topic Re: AND mode in listbox in QlikView

AND mode in listbox

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

Hi,

I would like to have an easy example (only few rows INLINE) of using of AND-mode in a listbox.

Can anybody help me?

Thanks

Re: AND mode in listbox

Chanty4u — Tue, 17 May 2016 11:21:49 GMT

chk dis

AND-mode in List Boxes ‒ QlikView

Re: AND mode in listbox

swuehl — Tue, 17 May 2016 11:41:35 GMT

Or maybe this:

AND-Mode‌

AND and OR

Re: AND mode in listbox

santiago_respane — Tue, 17 May 2016 12:08:30 GMT

Hi Juan,

Attached you will find and example.

In it you have an example with the fields actor and film.

Qlikview's default behavior is to show all the movies that they both worked in but not strictly together.

If we want to know which actors worked together in a movie we must create create a table with distinct records between actors and movies, the field ANDACTOR will be enabled to run in AND MODE.

In the example if you select Tom Cruise and Brad Pitt in the Actor listbox you will find all movies each actor worked, if select them in the ANDActor list box you will find the movies that they worked together.

Let me know if this helps.

Kind regards,