topic Re: Cross Database Selection in QlikView

Cross Database Selection

Roop — Wed, 14 Nov 2012 09:57:45 GMT

I am looking to a solution whereby the results of a search on one database can be used in a selection for another one.

Very simply I want to query a database using a certain set of parameters and for this to return a list of items that could subsequently used in a query for another database.

e.g.

From Database 1

Select itemnum where maturedate = today

From Database 2

Select itemnum, otherDate, Descriptor - using Database 1 query list

Thank you

Re: Cross Database Selection

Wed, 14 Nov 2012 11:29:09 GMT

Maybe

Select1:

LOAD relavant feilds;

sqlselect db;

varWHERE1 = peek ('feild',0,'Select1');

select2:

Load relevant feilds;

sqlselect db where feild = varWHERE1;

or do the loads before, then res load with loop, use iterator insted of index 0 to make it dynamic

Re: Cross Database Selection

Wed, 14 Nov 2012 11:29:25 GMT

not sure if that helps but its a guess