topic Creating a button with an "or" function in QlikView

Creating a button with an "or" function

Mon, 06 May 2013 15:10:30 GMT

Sorry all, newbie question here.

I have two seperate fields - 1. Design, 2. Effectiveness

Each field has four options - Red, Amber, Green, N/A

I want to create a button that will select all items that are red or amber for either the Design or Effectivness (i.e. Design - Green, Effectivenss - Amber should show up).

Is this possible?

Really appreciate the help!

Re: Creating a button with an "or" function

calvindk — Mon, 06 May 2013 15:27:46 GMT

Yes, start by creating the button. Then in ACTION, you click ADD and then add SELECT IN FIELD

In the field you enter Design

In the search string try

='(Red|Amber)'

Re: Creating a button with an "or" function

Mon, 06 May 2013 15:32:31 GMT

Thanks Anders.

I'd like to take it a step further though.

How do I say if Design = '(Red/Amber)' OR Effectiveness = '(Red/Amber)'

Re: Creating a button with an "or" function

calvindk — Mon, 06 May 2013 15:38:11 GMT

Well you add an extra action to the button that does it for the other field

Re: Creating a button with an "or" function

Mon, 06 May 2013 18:07:09 GMT

I tried that but it is now only showing me instances where both the Design and Effectiveness fields are amber/red. I'd like to switch it to an or...

Re: Creating a button with an "or" function

calvindk — Tue, 07 May 2013 07:58:00 GMT

if i understand correctly you want anything showing up that has either a amber/green rating in design or a green/amber rating in effectiveness.

This can be done if you have another value to select, such as an id.

Instead of selecting the green/amber then you select the corresponding id's.