topic Re: Logical condition in Button in QlikView

Logical condition in Button

Wed, 27 Jan 2016 20:20:48 GMT

Hi,

I have two actions in a button. By default it displays the data even if one of them is true. I want the data to be filtered on both the conditions i.e I need a logical 'and' and not the default logical 'or'. So, I am trying to construct an expression in the button using the logical 'and'. Please assist me if my syntax is wrong.

My qlikview document is attached.

Thanks,

Sudha.

Re: Logical condition in Button

sunny_talwar — Wed, 27 Jan 2016 20:24:38 GMT

Your first button seems to be working the way you want. Isn't that what you want?

For your second button, a single Select in Field action cannot make selections in two different fields.

Re: Logical condition in Button

Wed, 27 Jan 2016 20:29:30 GMT

The first button works fine. Please have a look at the third button 'Expired (or) Expiring Today'. It has two conditions. Ideally, no data should be selected because no data satisfies both the condition but because the button action is a logical 'or' I get some data that satisfies one of the condition. Hence, I want to manipulate the whole thing in the expression as shown in the fourth button 'Expired (or) Has a reason for Delay'. Hope this helps.

Re: Logical condition in Button

sunny_talwar — Wed, 27 Jan 2016 21:38:43 GMT

I think the logic is and (and not or), but just because you don't have 'Test Evidence' as a selection available for today's date, you are unable to select anything in TEST_CASE_STATUS.

Try the third button now and see if this works.

Re: Logical condition in Button

Thu, 28 Jan 2016 15:29:41 GMT

Hi,

I couldn't understand the expression you had given. I don't see anything selected when I click on the third button. Please help me understand your expression and also the reason why the below expression is not working -

=TEST_CASE_STATUS='Testing Evidence' AND TEST_EXPIRATION_DT=Date((Today()+1),'MM/DD/YYYY')