Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
adoteykwame
Creator
Creator

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
alexandros17
Partner
Partner

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

View solution in original post

5 Replies
alexandros17
Partner
Partner

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

View solution in original post

Not applicable

Hi,

Try

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

Rebeca

kumarnatarajan
Partner
Partner

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

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
Creator
Creator
Author

That was very helpful, Thanks alot guys