Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Editing QVD

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

5 Replies
maxgro
MVP
MVP

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);

Not applicable
Author


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?

maxgro
MVP
MVP

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).

Not applicable
Author

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?

maxgro
MVP
MVP

see attachment, and image

1.png