Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Specific data (few item numbers) in Load

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Load *

From ...

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

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Load *

From ...

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

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

stabben23
Partner - Master
Partner - Master

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.

Not applicable
Author

Thanks, this is what I needed.