Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in tutorial - Loading the info table

I am doing lesson 17 (Loading the info table) of the free tutorial given at - http://www.qlik.com/~/media/Files/training/tutorials-qv11/English.ashx

This link has everything you need for this question.

I did everything, but I cannot see any country's flag when I select it. Please help me to fix this.

Steps -

The next step is to load the info table into QlikView.

1 Choose  Edit Script.

2 Position the cursor at the end of the script and click  Table Files .

3 Select the file FlagsOECD.csv and click  Open . This opens the file wizard.

4 Just like for the files already loaded,  Delimited is set as type,  Comma as

delimiter.  Embedded Labels is selected as label.

5 Click  Finish .

The statement generated will load the file FlagsOECD.csv as a regular data file.

However, this is not what you want to do: you would like QlikView to use Flags-

OECD.csv to link information to specific field values. This is done in the following

way:

6 Change the script by manually adding the word  info before the  load state-

ment. As the word  info is a keyword in the script, it will turn blue. The script

should look similar to the following:

Directory;

INFO LOAD Country,

Flag

L INKING EXTERNAL INFORMATION TO A DOCUMENT

Creating a document 175

FROM Data Sources\FlagsOECD.csv (txt, codepage is

1252, embedded labels, delimiter is ',', msq);

7 Click  Reload .

8 The  Fields page is opened. No new fields have been added. Click  OK .

9 Save your work.

Viewing the linked information

To view the information you have linked, do the follow-

ing:

1 Select Germany from the list of countries.

2 A small info symbol appears in the upper right-

hand corner of the list box. Click it.

An independent window containing Germany’s flag

now appears in the document.

Note The relative paths from the QlikView document to the image files must be

stated correctly in the info table for this to work.

3 Close the window

4 Select France from the list of countries.

5 Click the info symbol to make the specified picture appear.

1 Reply
Anonymous
Not applicable
Author

Hi John!

I had the same problem until I realised that there are only image files for some countries included in the tutorial.

Try selecting for example Germany or Australia and the flag will appear.

Br

/Per