topic Re: Editing QVD in QlikView

Editing QVD

Tue, 21 Jul 2015 20:28:07 GMT

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

Re: Editing QVD

maxgro — Tue, 21 Jul 2015 20:55:55 GMT

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

Re: Editing QVD

Wed, 22 Jul 2015 18:55:56 GMT

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?

Re: Editing QVD

maxgro — Wed, 22 Jul 2015 19:20:17 GMT

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

Re: Editing QVD

Wed, 22 Jul 2015 19:48:35 GMT

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?

Re: Editing QVD

maxgro — Wed, 22 Jul 2015 20:35:59 GMT

see attachment, and image