topic Re: Selection AND in list box in QlikView

Selection AND in list box

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

Hi all,

In my example in the attached file, when i select seller 01/02 i'd like to obtain only sales with seller 01 AND 02, not sales with seller 01OR 02. How to achieve this?

Regards

Re: Selection AND in list box

swuehl — Mon, 06 Feb 2017 19:10:46 GMT

You can enable the AND mode like described in

AND-Mode

Qlik Tips: AND Mode in list boxes

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/And-mode%20in%20List%20Boxes.htm

Re: Selection AND in list box

sergio0592 — Mon, 06 Feb 2017 19:46:38 GMT

Thanks Stefan, but do you know if user can swith AND/OR mode via Access Point or i have to duplicate List box with one AND and one OR??

Re: Selection AND in list box

swuehl — Mon, 06 Feb 2017 19:55:56 GMT

It's not only that you need to enable the list box and-mode, the data model must be set up to meet some few requirements (they are described in detail in the referenced links).

So, in general it's not possible to enable the use to switch between modes.

Re: Selection AND in list box

MarcoWedel — Mon, 06 Feb 2017 21:59:57 GMT

Hi,

instead of switching the listbox mode maybe one solution might be something like:

hope this helps

regards

Marco

Re: Selection AND in list box

swuehl — Mon, 06 Feb 2017 23:13:04 GMT

Jean-Baptiste,

here is a more detailed explanation of how AND mode works in QlikView list boxes:

AND and OR

Re: Selection AND in list box

Anonymous — Tue, 07 Feb 2017 00:24:56 GMT

Hi.

Have you tried Pivot Table?

1)modify the sum([Sales €]) chart you have on your sample to Pivot table.

2)add "Seller_Id" as the first dimension and "Transac" as 2nd.

3) in Presentation Tab check the "Show Partial Sums" box.

the pivot will display according to your filters, unless you want to do a set analysis which will fix the result to a particular filter.

Re: Selection AND in list box

sergio0592 — Tue, 07 Feb 2017 20:40:33 GMT

So, in propertie/ General, i'am unable to check AND Mode!

Re: Selection AND in list box

swuehl — Tue, 07 Feb 2017 20:56:18 GMT

Have you set up the and mode list box field correctly, as described in the tech doc?