topic How to limit data in script? in QlikView https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007666#M964848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I just need to load only the highlighted values.</P><P></P><P><IMG __jive_id="101129" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101129_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 06 Oct 2015 14:08:29 GMT MuraliPrasath 2015-10-06T14:08:29Z How to limit data in script? https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007666#M964848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I just need to load only the highlighted values.</P><P></P><P><IMG __jive_id="101129" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101129_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 06 Oct 2015 14:08:29 GMT https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007666#M964848 MuraliPrasath 2015-10-06T14:08:29Z Re: How to limit data in script? https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007667#M964849 <HTML><HEAD></HEAD><BODY><P>In your script, add a WHERE clause to the LOAD statement that forces a load of only these values.</P><P></P><P>Peter</P></BODY></HTML> Tue, 06 Oct 2015 14:12:01 GMT https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007667#M964849 Peter_Cammaert 2015-10-06T14:12:01Z Re: How to limit data in script? https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007668#M964850 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">WHERE Match(ESFA_Sales_Rep__c, 'Aaron Fox', 'Adam Harris', 'Adrian Meyer', 'Andre Andrade');</SPAN></P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Tue, 06 Oct 2015 14:14:40 GMT https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007668#M964850 Peter_Cammaert 2015-10-06T14:14:40Z Re: How to limit data in script? https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007669#M964851 <HTML><HEAD></HEAD><BODY><P>load *</P><P>From table</P><P>WHERE match(YourField,'Value1','Valu2','Value3')</P></BODY></HTML> Tue, 06 Oct 2015 14:15:25 GMT https://community.qlik.com/t5/QlikView/How-to-limit-data-in-script/m-p/1007669#M964851 Kushal_Chawda 2015-10-06T14:15:25Z