Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adoteykwame
Contributor

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

Hi

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

1 Solution

Accepted Solutions

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

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

5 Replies

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

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

Not applicable

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

Hi,

Try

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

Rebeca

kumarnatarajan
Valued Contributor

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

hi,
try this
Ex:
where WildMatch(clicod,'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD');
narender123
Valued Contributor

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

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

adoteykwame
Contributor

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

That was very helpful, Thanks alot guys

Community Browser