topic Using results from one script to limit returned data from another script in QlikView https://community.qlik.com/t5/QlikView/Using-results-from-one-script-to-limit-returned-data-from/m-p/424683#M158181 <HTML><HEAD></HEAD><BODY><P>I have a Qlikview report that will be accessing data frp, 3 different SQL Servers on three different machines.&nbsp; Is there any way for me to use the results of the script against the first database to limit what is pulled from the other databases?&nbsp; For example, let's say all three databases have tables with a Company ID field.&nbsp; My first query will return a list of CompanyIDs.&nbsp; Is there any way for the next scripts to use those CompanyID values from that first script to limit the data pulled by the next two scripts to just the pertinent CompanyIDs?</P></BODY></HTML> Wed, 17 Oct 2012 18:23:23 GMT 2012-10-17T18:23:23Z Using results from one script to limit returned data from another script https://community.qlik.com/t5/QlikView/Using-results-from-one-script-to-limit-returned-data-from/m-p/424683#M158181 <HTML><HEAD></HEAD><BODY><P>I have a Qlikview report that will be accessing data frp, 3 different SQL Servers on three different machines.&nbsp; Is there any way for me to use the results of the script against the first database to limit what is pulled from the other databases?&nbsp; For example, let's say all three databases have tables with a Company ID field.&nbsp; My first query will return a list of CompanyIDs.&nbsp; Is there any way for the next scripts to use those CompanyID values from that first script to limit the data pulled by the next two scripts to just the pertinent CompanyIDs?</P></BODY></HTML> Wed, 17 Oct 2012 18:23:23 GMT https://community.qlik.com/t5/QlikView/Using-results-from-one-script-to-limit-returned-data-from/m-p/424683#M158181 2012-10-17T18:23:23Z Re: Using results from one script to limit returned data from another script https://community.qlik.com/t5/QlikView/Using-results-from-one-script-to-limit-returned-data-from/m-p/424684#M158182 <HTML><HEAD></HEAD><BODY><P>Look into a WHERE clause with EXISTS() functions, that you can use in a LOAD statement.</P></BODY></HTML> Wed, 17 Oct 2012 18:42:42 GMT https://community.qlik.com/t5/QlikView/Using-results-from-one-script-to-limit-returned-data-from/m-p/424684#M158182 swuehl 2012-10-17T18:42:42Z