topic Re: Where.....command contains unrecognised pharse/keyword in QlikView

Where.....command contains unrecognised pharse/keyword

Anonymous — Mon, 03 Jun 2013 12:28:34 GMT

trying to load a table with this where clause but instead i get the above script error

WHERE clicod = 'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD';

Re: Where.....command contains unrecognised pharse/keyword

alexandros17 — Mon, 03 Jun 2013 12:36:40 GMT

the syntax is:

where clicod = 'BX' Or clicod = 'BI' OR ....

if you are writeing a query in sql you can write

where clicod in ('BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD')

Hope it helps

Re: Where.....command contains unrecognised pharse/keyword

Mon, 03 Jun 2013 12:37:11 GMT

Hi,

Try

WHERE clicod IN( 'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD');

Rebeca

Re: Where.....command contains unrecognised pharse/keyword

kumarnatarajan — Mon, 03 Jun 2013 12:43:58 GMT

hi,

try this

Ex:

where WildMatch(clicod,'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD');

Re: Where.....command contains unrecognised pharse/keyword

narender123 — Mon, 03 Jun 2013 12:44:08 GMT

Hi,

Try this,

WHERE clicod = 'BX' or 'clicod='BI' or clicod='BW' or clicod='BS' or clicod='BF' or clicod='BL' or clicod='BT' or clicod='BA' or clicod='BE' or clicod='BP' or clicod='BM' or clicod='BK' or clicod='BD';

Thanks

Narender

Re: Where.....command contains unrecognised pharse/keyword

Anonymous — Mon, 03 Jun 2013 13:16:36 GMT

That was very helpful, Thanks alot guys