Hello my friends. I am fairly new to QlikView and am really struggling with some of the basic concepts of the program. My background is in Access to some of the QV syntax is very different to me. For example, in Access, I could tell someone just starting out that the way to create a db app is to connect to an ODBC, link to specific tables, query those tables and then generate reports off of said queries. In QV this does not seem to be the case. I have successfully connected to my ODBC and brought in four different tables. I have qualified each table to make it easier (I thought) to then join certain fields together. This has proved incredibly frustrating for me. I keep getting synthetic keys and have been told that they are a bad thing. Please, would someone take the time to break down for me how you would go about structuring an easy program in QV.
Example:
01. CONNECT to ODBC_y; 02. QUALIFY *; 03. tblName_A: 04. SELECT * 05. FROM tblName_A 06. WHERE condition; 07. UNQUALIFY *; 08. 09. CONNECT to ODBC_z; 10. QUALIFY *; 11. tblName_B: 12. SELECT * 13. FROM tblName_B 14. WHERE condition; 15. UNQUALIFY *;
Now how do I merge these two tables together into one?
Thank you so much for the quick response Jagan. Unfortunately I “think” what I am trying to do is an inner join. My first example was vague. Basically the first section of code was bringing in two tables. Now that I have two tables, they each have a field (for example, tblName_A.him in the first table and tblName_B.her in the second) that I need to join on.I am not sue of the syntax to make this join with two fields from different tables that have different names but the same data in them…
Qlikview can be a little odd when first starting out, but your experience in Access will help you learn quickly. Essentially what you are trying to do in QV is denormalise the data model to a star schema instead of separate tables you would find in a traditional RDBMS. QV handles the storage of duplicated data for you, and less tables in memory will generally perform quicker.
I would avoid Select * statements because you could lose control of your QV datamodel (eg. if a new field is added to your datasource which has a field name existing elsewhere they will create a possibly unwanted join). I highly recommend the free online courses and buying a good book - Qlikview11 for Developers by Miguel Garcia and Barry Harmsen is highly recommended, but there are others. I've been using QV for 7 years but still picked up more knowledge than I expected from these publications.
