topic Re: Button to select multiple fields with logical OR in QlikView

Button to select multiple fields with logical OR

Anonymous — Thu, 04 Jun 2015 21:16:03 GMT

Hello,

I'm trying to find a way to have a selection of 2 fields with a button.

What I basically want is a button that shows

Sold items that are marked as 'Sold' in the field 'Status'

Sold items that are marked as 'Sold' in the field Inventory

so basically a button with:

Select in Field: Status OR Inventory

Search String: *Sold*

is that somehow possible?

Re: Button to select multiple fields with logical OR

antoniotiman — Thu, 04 Jun 2015 22:21:34 GMT

Hi,

If You have

Field,Status,Inventory

A, a, Sold

B, Sold, b

..........

If You select A, You exclude B.

However ,You can add to script

Load *,

If(Status='Sold' or Inventory='Sold',1) as Flag;

Load * from .......; // or SQL Select * from ...;

Then in Your Button -> Select -> Action -> Select in Field Flag -> 1.

Also You can use expression like

Sum({<Status={'Sold'}>+<Inventory={'Sold'}>} Value)

in your objects.

Regards,

Antonio

Re: Button to select multiple fields with logical OR

swuehl — Thu, 04 Jun 2015 22:27:28 GMT

Basically you want to select Items, right?

Try creating a button with action Select - Select in field

Field:

Item

Search string:

='=Status like ' & chr(39) & '*Sold*' & chr(39) & ' or Inventory like ' & chr(39) & '*Sold*' & chr(39)

Re: Button to select multiple fields with logical OR

petter — Thu, 04 Jun 2015 22:29:25 GMT

Well the simplest and most straightforward approach I think might be to have a small two column table generated like this in your load script:

AbsolutelySold:

LOAD

Item,

(Status = 'Sold') AS DefinitelySold

RESIDENT

TableWithTheField_Status;

LOAD

Item,

(Inventory = 'Sold') AS DefinitelySold

RESIDENT

TableWithTheField_Inventory;

If the two fields are in the same table you can simplify it like this:

AbsolutelySold:

LOAD

Item,

(Status = 'Sold' Or Inventory = 'Sold') AS DefinitelySold

RESIDENT

TableWithTheTwoFields_Status_and_Inventory;

In you application you can have the field DefinitelySold in a list box and that will act as your button.

Re: Button to select multiple fields with logical OR

bwohletz — Fri, 27 Sep 2019 11:29:27 GMT

@swuehl you are the boss, what an elegant solution, I had to play with the syntax a bit but now it is working,txs

Re: Button to select multiple fields with logical OR

manideep78 — Fri, 02 Apr 2021 15:24:22 GMT

Hi @swuehl

I know this is very old post but I have similar requirement.

I tried to use the same logic and it didn't work.

the Item field you mentioned here is not in context.

can you please elaborate little more?

Re: Button to select multiple fields with logical OR

manideep78 — Fri, 02 Apr 2021 15:29:09 GMT

Hi @bwohletz

I have similar requirement like this, it the syntax worked?

you just have Status and Inventory fields but not sure how Item came into context.