HI all, thanks in advance for your help.
Here is my problem, my company has purchased Qlik and I am tasked with learning it to teach our end users. I am going through the Qlik provided activity book to learn how Qlik works. (April 2016 Release, Qlik v2.2 book of Qlik Modeling for Qlik Sense). I am having some difficulty because the described behavior in the book is not matching the observed behavior of the tool. This is due to in part, I think, that we are using v3.0 instead of v2.2 (if anyone knows of v3.0 learning material that would be AWESOME). Currently I am trying to work through the data market section. (pg. 194) .
The described behavior is that I get data from the market free section, and dowload country population data.
"6. On the Select data to load step, select the following
- Country: Country - this should select every country in the list
- Sex: Total
-Age Group: Total
- Year: Most Recent
7. Click load data and finish
8. Click close
9. Open the Data manager from the Navigation menu. Notice that only the World Population by Country table has edit and delete icons when you hover over.
11. Preview the new table and check the field values. Country and Persons are the only two fields you need to keep...."
This indicates that at this point of the manual that only one table has been downloaded. In fact 4 tables have loaded, one for each selection with FK in the World Population by Country pointing to the Country, Sex, and Age Group tables.
Fine, something has changed from printing to today, so here is my problem. I want to convert these 4 tables to one table, specifically I want one table with Country and Persons (per the manual instructions for this activity). The problem is that EVERY TIME I try to join Country and World Population by Country the resulting table is a Cartesian product. The Country table and the WPbC table both have 228 rows of data I have triple (x1000) checked the column names, qlik data modeler recognizes the connection between the two tables (column: _dim_8q8e) , if I leave everything "as i"s and create a sheet in the App Overview and check the results by dropping country and persons into a table, everything is fine. I get 228 rows of data. When I copy these tables into temp tables I get 228 rows apiece, But as soon as I try to join country into the WPbC table or Persons into the Country temp tables I get 228x228 rows of data. Here is my code :
Persons as WpPersons,
_dim_8q8e AS countryID
RESIDENT [World population by country];
Country as wpCountry
_dim_8q8e as countryID,
Country //as Con_con
//Here is new table
WpPersons as Population,
countryID as CID
//RESIDENT [World population by country];
INNER JOIN (WorldPop)
Country AS CT_Country
//RESIDENT Country ;
Does anybody see why this results in Cartesian product?