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
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.
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.
