Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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