https://community.qlik.com/t5/QlikView/How-to-filter-the-data-from-qvd-still-maintaining-it-as/m-p/2003253#M1221458 <P>Hi all,&nbsp;</P> <P>Assume a QVD of 10 GB data with 15 field/columns, one of the field/column named 'Countries' .Here 'Countries'&nbsp; 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.&nbsp;</P> <P>Thanks in advance.&nbsp;</P> Thu, 10 Nov 2022 19:34:08 GMT Sreenu4Cherry 2022-11-10T19:34:08Z https://community.qlik.com/t5/QlikView/How-to-filter-the-data-from-qvd-still-maintaining-it-as/m-p/2003253#M1221458 <P>Hi all,&nbsp;</P> <P>Assume a QVD of 10 GB data with 15 field/columns, one of the field/column named 'Countries' .Here 'Countries'&nbsp; 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.&nbsp;</P> <P>Thanks in advance.&nbsp;</P> Thu, 10 Nov 2022 19:34:08 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-from-qvd-still-maintaining-it-as/m-p/2003253#M1221458 Sreenu4Cherry 2022-11-10T19:34:08Z https://community.qlik.com/t5/QlikView/How-to-filter-the-data-from-qvd-still-maintaining-it-as/m-p/2003333#M1221460 <P>TempCountries:<BR />LOAD * Inline [<BR />Country<BR />US<BR />France<BR />Germany<BR />];</P> <P>Facts:<BR />LOAD * From myqvd.qvd (qvd)<BR />Where exists(Country);</P> <P>-Rob</P> Fri, 11 Nov 2022 04:32:01 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-from-qvd-still-maintaining-it-as/m-p/2003333#M1221460 rwunderlich 2022-11-11T04:32:01Z