topic Re: Specific data (few item numbers) in Load in QlikView

Specific data (few item numbers) in Load

Mon, 26 Jan 2026 18:19:17 GMT

Very simple question: in a QVD I have over 20.000 item numbers. However in my report I just need four of those. How do I just load those 4 item numbers in my script?

Thanks in advance.

Re: Specific data (few item numbers) in Load

Anonymous — Mon, 14 Nov 2016 13:12:26 GMT

Load *

From ...

where match(ItemNo,'1','2','3','4');

=> Replace with your itemNo's - the specified text must be an exact match.

Re: Specific data (few item numbers) in Load

stabben23 — Mon, 14 Nov 2016 13:18:23 GMT

Hi,

Items is often a part of the fact table and also a part of its own dimensiontable.

So if you filter the items you want in Your dimensiontable With something like: where match(item,1,2,3,4)

then in facttable use: where exists(item,item).

this will reduce Your Whole datamodel to contain only Your 4 items.

Re: Specific data (few item numbers) in Load

Mon, 14 Nov 2016 13:24:48 GMT

Thanks, this is what I needed.