Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this QVD file containing information regarding the Latitude and Longitude and the Country boundary information along with the 3 letter country code. I want to add another column containing list of all countries in full form. Can you guys please help me out how to do it? I have my deadline in two days to generate Qlikmaps
CountryMap:
Mapping LOAD
[Alpha-3 code],
[English short name (upper/lower case)]
FROM
[https://en.wikipedia.org/wiki/ISO_3166-1]
(html, codepage is 1252, embedded labels, table is @1);
Country:
LOAD Name,
ApplyMap('CountryMap', Name) as Name2,
Description,
FeaturesBoundary,
Lat, Lng
FROM
world.qvd
(qvd);
store Country into Country2.qvd (qvd);
I am new to Qlikview. I understood the script, what does "store Country into Country2.qvd (qvd);" mean?
where Will there be a Country2.qvd being created if it doesn't exist?
How do I save this as another QVD?
Save the table Country in Country2.qvd file on your file system so you can reuse it with Qlik as .qvd is a Qlik proprietary format (example you can read Country2.qvd in a different .qvw).
If Country2.qvd exists it will be overwritten, if not created.
store Country into SecondCountry2.qvd (qvd); will creates a new .qvd.
store Country into ThirdCountry2.qvd (qvd); .......................
..........................
There is an useful tool to read a qvd file qviewer.
And also there is an useful help in Qlik (for store).
I executed the script, when I open the country2.qvd the "Name2" field is empty. The data is not populated in Name2. Can you please help me out with what the issue might be?
see attachment, and image