topic Re: Conditions within Search String Button - Syntax in QlikView

Conditions within Search String Button - Syntax

Sat, 12 Sep 2015 17:49:23 GMT

Hi,

Could you please help me how to add a third condition to the below conditions and also please help me with the syntax for handling not equal to.

='=TEST_CASE_STATUS=' & chr(39) & 'Expired' & chr(39) & ' OR NOT ISNULL(REASON_FOR_DELAY)' & 'AND ' & '=RULE_DESIGNATION=' & chr(39) & '<>Manual' & chr(39)

I have the following questions:

1. How to club first and second condtion i.e Test_case_status='Expired' or REASON_FOR_DEALY is not null. Just a bracket will work?

2. How to add a third condition to this? ...& 'AND ' & '=RULE_DESIGNATION=' & chr(39) & '<>Manual' & chr(39) - This does not work

3. How to handle not equal to? '=RULE_DESIGNATION=' & chr(39) & '<>Manual' & chr(39) - This does not work too.

Thanks,

Sudha.

Re: Conditions within Search String Button - Syntax

sunny_talwar — Sun, 13 Sep 2015 04:31:21 GMT

Not exactly sure where you are using this, but give this a try:

='=(TEST_CASE_STATUS=' & chr(39) & 'Expired' & chr(39) & ' OR NOT ISNULL(REASON_FOR_DELAY)) AND RULE_DESIGNATION <>' & chr(39) & 'Manual' & chr(39)

Re: Conditions within Search String Button - Syntax

Mon, 14 Sep 2015 13:01:20 GMT

Thank you so much! I was stuck with this syntax. It's working now!

Re: Conditions within Search String Button - Syntax

sunny_talwar — Mon, 14 Sep 2015 13:04:30 GMT

Awesome

I am glad your got it all figured. I would suggest closing this thread by marking correct or helpful answer.

Best,

Sunny