Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Sreenu4Cherry
Contributor
Contributor

How to filter the data from qvd still maintaining it as optimized load?

Hi all, 

Assume a QVD of 10 GB data with 15 field/columns, one of the field/column named 'Countries' .Here 'Countries'  field contains 20 distinct countries. Scenario here is to apply some transformation to filter only 5 countries and still to maitain it as optimized load. 

Thanks in advance. 

Labels (2)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

TempCountries:
LOAD * Inline [
Country
US
France
Germany
];

Facts:
LOAD * From myqvd.qvd (qvd)
Where exists(Country);

-Rob