Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

Scripting problem- extracting certain data from a qvd

Hi i have imported various qvds into my qlikview document. One of them being a product qvd that contains thousands of product numbers. I would like to ask how i would specify in the script to only load a certain view of these products

for example

501,502,503,504

These are all product numbers

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Aaron,

Load *

From

Product.qvd (qvd)

Where Match(Product_Field, '501','502','503','504')

You can also try like below

Product:

LOAD * INLINE [

    Products_To_Load

    501

    502

    503

    504

];


Data:

Load *

From

Product.qvd (qvd)

Where Exists(Products_To_Load, Product_Field);


DROP Table Product;

View solution in original post

1 Reply
tamilarasu
Champion
Champion

Hi Aaron,

Load *

From

Product.qvd (qvd)

Where Match(Product_Field, '501','502','503','504')

You can also try like below

Product:

LOAD * INLINE [

    Products_To_Load

    501

    502

    503

    504

];


Data:

Load *

From

Product.qvd (qvd)

Where Exists(Products_To_Load, Product_Field);


DROP Table Product;