topic WHERE CONDISION ERROR in QlikView

WHERE CONDISION ERROR

yadav_anil782 — Thu, 16 Jul 2015 12:06:12 GMT

Hi Experts,

1st condision - i dont want "1,2,4,10 " from BOOKING_STATUS column

2st condision- i dont want "APPROVED" and "INPROGRESS" from APPROVAL_STATUS colummn

i'm using this where condision for my requirement-

WHERE (BOOKING_STATUS <> '1' OR '2'OR '4'OR'10') AND (APPROVAL_STATUS <> 'APPROVED' OR APPROVAL_STATUS <> 'INPROGRESS');

Re: WHERE CONDISION ERROR

sunny_talwar — Thu, 16 Jul 2015 12:09:38 GMT

Try this if both condition has to be met:

Where not Match(BOOKING_STATUS, 1, 2, 4, 10) and not Match(APPROVAL_STATUS, 'APPROVED', 'INPROGRESS');

If its either or conditions, then try this:

Where not Match(BOOKING_STATUS, 1, 2, 4, 10) or not Match(APPROVAL_STATUS, 'APPROVED', 'INPROGRESS');

Re: WHERE CONDISION ERROR

swuehl — Thu, 16 Jul 2015 12:09:40 GMT

WHERE NOT MATCH(BOOKING_STATUS,'1','2','4',10') AND (APPROVAL_STATUS <> 'APPROVED' OR APPROVAL_STATUS <> 'INPROGRESS');

Re: WHERE CONDISION ERROR

MayilVahanan — Thu, 16 Jul 2015 12:11:03 GMT

Try like this

Where Not Match(BOOKING_STATUS , 1,2,4, 10) And Not match(APPROVAL_STATUS, 'APPROVED' , 'INPROGRESS');

Re: WHERE CONDISION ERROR

alexandros17 — Thu, 16 Jul 2015 12:13:18 GMT

If you want to use your original query write:

WHERE (BOOKING_STATUS <> '1' and BOOKING_STATUS <> '2' BOOKING_STATUS <> '4' BOOKING_STATUS <> '10') AND (APPROVAL_STATUS <> 'APPROVED' and APPROVAL_STATUS <> 'INPROGRESS');