There are loads of data source on the internet.
Here is an example loading a List of sovereign states and dependent territories by population density from Wikipedia.
LOAD Pos.,
[Country (or dependent territory)],
[Area (km²)],
[Area (mi²)],
Population,
[Density (pop./km²)],
[Density (pop./mi²)],
Date,
[Population source]
FROM
[http://en.wikipedia.org/wiki/Countries_by_population_density]
(html, codepage is 1252, embedded labels, table is @1);
In the script editor click on <Web Files> and you'll get a wizard to guide you through.
Here is another one getting weather data
////////////////////////////////
let vURL = 'http://api.openweathermap.org/data/2.5/forecast/daily?id=' & '$(vId)' & '&mode=xml&units=metric&cnt=14' ;
////////////////////////////////
////////////////////////////////
Time:
////////////////////////////////
LOAD
$(vId) as id ,
date(day) as [Date] ,
weekday(date([Date])) as [Weekday] ,
MonthName(date(day)) as [Month Year] ,
Capitalize ( [clouds/value] ) as [Cloud Value] ,
[clouds/all]/100 as [Cloud Cover] ,
[humidity/value]/100 as [Humidity Value] ,
[pressure/value] as [Pressure Value] ,
[temperature/day] as [Temp Day] ,
[temperature/min] as [Temp Min] ,
[temperature/max] as [Temp Max] ,
[temperature/night] as [Temp Night] ,
[temperature/eve] as [Temp Evening] ,
[temperature/morn] as [Temp Morning] ,
[windSpeed/mps] as [Wind Speed mps] ,
[windSpeed/mps] * 2.23693629 as [Wind Speed mph] ,
[windSpeed/mps] * 3.6 as [Wind Speed kph] ,
Capitalize ( [windSpeed/name] ) as [Wind Speed Name] ,
[windDirection/deg] as [Wind Direction Deg] ,
[windDirection/code] as [Wind Direction Code] ,
Capitalize ( [windDirection/name] ) as [Wind Direction Name] ,
if ( LEN([precipitation/value]) = 0 , 0.00 , num([precipitation/value] )) as [Precipitation Value] ,
Capitalize ( [precipitation/type] ) as [Precipitation Type] ,
Capitalize ( [symbol/name] ) as [Symbol Name]
FROM $(vURL)
(XmlSimple, Table is [weatherdata/forecast/time]);
////////////////////////////////
////////////////////////////////
WeatherData:
LOAD
ApplyMap ( 'IdMap' , [location/name] ) as id ,
time ( time(Mid([sun/rise],12,5)) ) as [Sun Rise],
time ( time(Mid([sun/set],12,5)) ) as [Sun Set],
date(Left([meta/lastupdate],10)) as [Date Updated] ,
timestamp ( date(Left([meta/lastupdate],10)) + time(Mid([meta/lastupdate],12,5)) ) as [Last Updated],
time([meta/calctime]) as [Calc Time] ,
timestamp ( date(Left([meta/nextupdate],10)) + time(Mid([meta/nextupdate],12,5)) ) as [Next Update],
[location/name] as [Location] ,
// [location/country] as [Country] ,
[location/location/altitude] as [Altitude] ,
[location/location/latitude] as [Latitude] ,
[location/location/longitude] as [Longitude]
FROM $(vURL)
(XmlSimple, Table is [weatherdata]);
////////////////////////////////
Openweathermap.org had loads of weather related data that is good for practising QlikView on.
