topic Re: Filter Records in Script in QlikView

Filter Records in Script

Thu, 20 Sep 2012 18:38:28 GMT

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!

Thu, 20 Sep 2012 18:47:09 GMT

Hi,

one way would be with like statement:

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

regards

Thu, 20 Sep 2012 20:00:59 GMT

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