list box

[ReneeWu]

Hi everyone,

I have a problem , any help is appreciated.

As below table. I want to add a list box to filter Product. It can show lines which buy both Product A & Product B .

Now, if I select Product A & Product B from the list box , it will show any Order No which contain Product A & Product B. Like below Result.

But , actually I don't want to show lines expect Product A & Product B.

Is there any possible way to achieve it ?

Thanks in Advance!

Table:

Order No	Customer	Product
001	Wu	A
001	Wu	B
002	Li	C
003	Yang	A
003	Yang	B
003	Yang	D
004	Zhao	E

Result:

Order No	Customer	Product
001	Wu	A
001	Wu	B
003	Yang	A
003	Yang	B
003	Yang	D

[tresesco · Accepted solution]

@ReneeWu ,

You can explore AND-Mode in qlikview list box : https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/And-mode%20in%2...

https://community.qlik.com/t5/Qlik-Design-Blog/AND-Mode/ba-p/1471352#:~:text=Well%2C%20AND%2DMode%20....