Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-10-17 02:23 PM

Using results from one script to limit returned data from another script

I have a Qlikview report that will be accessing data frp, 3 different SQL Servers on three different machines.  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?  For example, let's say all three databases have tables with a Company ID field.  My first query will return a list of CompanyIDs.  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?

296 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2012-10-17 02:42 PM

Look into a WHERE clause with EXISTS() functions, that you can use in a LOAD statement.

220 Views
0 Likes
Community Browser