Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Referencing external data

Hi,

I'm currently doing that self-learning course "First steps" and I'm currently doing exercises on external data. I just played around with that "OECD" file (country flags), but I can't seem to get the hang of it.

The script just loads it, but does not state anything about what that info-file is connected to, so it should be associated automatically, no? The first column is labeled "country", so it should be associated with the table that has a column "country", no? I guess it works only once the column is unique (in only one table), so I renamed the column "CustCountry" and I also loaded the field "Country" once more as "CustCountry" from "customers.xls" - so now the flag_file should be associated with the field "CustCountry" in the table "Customers", no? Well, when I display the system_fields, it seems that this is the case - when I select "CustCountry" in "$Field", then the info_file in the table "$info" turns white and I can display the original file, just as I can display the original "Customers.xls" from the table "$Table".

When I select another worksheet, however, and from the listbox "CustCountry", I select a country that is in that info_file, I don't get the info_icon in the title_bar.

Can anybody tell me what I'm doing wrong?

0 Replies