Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Filter Records in Script

Am trying to filter item numbers in the script so item numbers that start with A through Z and items starting with 6DDP and 6DDR display.

Have tried many functions including sample below without any success

SQL SELECT *

FROM "Inventory Master File" WHERE WILDMATCH(ITEM_NUMBER ='A*' or 'B*' or 'C*' or '6DDP*' or '6DDR*');

Thank you in advance for your help!

Tags (1)
2 Replies
Not applicable

Re: Filter Records in Script

Hi,

one way would be with like statement:

...where ITEM_NUMBER like ‘A*’ or ITEM_NUMBER like ‘B*’ ...

regards

Not applicable

Re: Filter Records in Script

Thank you for your suggestion - I will give it a try.

Community Browser