Selection AND in list box

[sergio0592]

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

[swuehl]

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

[sergio0592]

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??

[swuehl]

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.

[MarcoWedel]

Hi,

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

hope this helps

regards

Marco

[swuehl]

Jean-Baptiste,

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

AND and OR

[Anonymous]

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.

[sergio0592]

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

[swuehl · Accepted solution]

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