topic Re: Preventing an obsolete item from loading in QlikView script in App Development

Preventing an obsolete item from loading in QlikView script

NickBentley — Thu, 18 Apr 2024 07:32:38 GMT

I am loading sales figures from a data set that now includes obsolete items. How do I prevent the items from loading in the script where the item number is 'Obsolete'

Sales_Data:

LOAD
Store_Number,

Item_Number,
Item_Category,

Thanks!

Re: Preventing an obsolete item from loading in QlikView script

mpc — Thu, 18 Apr 2024 07:35:33 GMT

Hi,

You can use:

Sales_Data:

LOAD
Store_Number,

Item_Number,
Item_Category
Where Not(Wildmatch(Item_Number, 'Obsolete' ));

Kind regards

Re: Preventing an obsolete item from loading in QlikView script

NickBentley — Thu, 18 Apr 2024 08:00:55 GMT

Thanks maximepiquetcointe!

Works as expected.

Re: Preventing an obsolete item from loading in QlikView script

BrunPierre — Thu, 18 Apr 2024 08:01:54 GMT

Hi, as below.

FROM ...
Where Match(Item_Number,'Obsolete') = 0;