Logical condition in Button

[#1]

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.

[sunny_talwar]

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.

[#3]

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.

[sunny_talwar]

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.

[#5]

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')