topic Referencing external data in QlikView https://community.qlik.com/t5/QlikView/Referencing-external-data/m-p/458767#M1153466 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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".</P><P>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.</P><P>Can anybody tell me what I'm doing wrong?</P></BODY></HTML> Wed, 20 Mar 2013 10:22:59 GMT datanibbler 2013-03-20T10:22:59Z Referencing external data https://community.qlik.com/t5/QlikView/Referencing-external-data/m-p/458767#M1153466 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>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".</P><P>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.</P><P>Can anybody tell me what I'm doing wrong?</P></BODY></HTML> Wed, 20 Mar 2013 10:22:59 GMT https://community.qlik.com/t5/QlikView/Referencing-external-data/m-p/458767#M1153466 datanibbler 2013-03-20T10:22:59Z