Query

Thu, 28 May 2009 04:29:37 GMT

Good evening,

my name's Marco and I'm a new utilizer of QlikView.

I have a problem and i hope that someone help me.

I have to connect 5 databases. These databases have many tables and this tables have common field.

I have to create a "multiple box" to create a graph in qlikview. In this box i need to select a field and in according to filed selction, have in output my graph.

I have tried to commect these 5 databases but the program give an error. After i have create only one database with all the tables that i need, this thime qlikview work well, but after if I insert a JOIN operation in my script to connect all the common field the program crash

I want to say if is possibile to connect multiple databse in my script and if this query is correct

SELECT*

FROM Mydatabase1 INNER JOIN Mydatabase2 ON Mydatabse1 .Myfield=Mydatabse2.Myfield2

Thank You

Query

johnw — Thu, 28 May 2009 04:37:34 GMT

Although you can join the databases together in SQL, a probably more typical approach would be to load the five databases into five different tables in QlikView. Make sure the common field gets the same name in all five tables. QlikView will then automatically handle the connection between the tables.

Query

Thu, 28 May 2009 05:09:22 GMT

Thank you soo much

topic Query in QlikView

Query

Query

Query