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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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