-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Qlikview Unlocked
By :
QlikView reads database tables, spreadsheets, XML files, and text files, but did you know that it can also take data from a web page? If you need some standard data from the Internet, there's no need to create your own version. Just grab it from a web page! How about ISO Country Codes? Here's an example.
Open the script and click on Web files… below Data from Files on the right-hand side of the bottom section of the screen. This will open the File Wizard: Source dialogue.
Enter the URL where the table of data resides:

Then, click on Next; in this case, choose @2 under Tables:

Click on Finish, and your script will look something similar to this:
LOAD F1,
Country,
A2,
A3,
Number
FROM
[http://www.airlineupdate.com/content_public/codes/misc_codes/icao_nat.htm]
(html, codepage is 1252, embedded labels, table is @2);Now, you've got a great lookup table in about 30 seconds—and another few seconds to clean it up for your own...
Change the font size
Change margin width
Change background colour