Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD files

Hi all,

I have a qlikview app which loads all the data from QVD files.

I need to add few columns and update the records and i dont have data stored in any other format(excel or csv).

How can i do that?

Basically how can i update/modify the QVD files???

Thanks

13 Replies
martinpohl
Partner
Partner

example:

you want to add a field (e.g. tx), the data is in a table where the sales number is matching at:

Map:

mapping load

salesno,

tax

from tax.csv;

//now read all qvd in a folder you want to edit (my example: all sales* files)

for each file in filelist('qvd\sales*.qvd');

//show the actual file in log

trace $(file);

//load data from the qvd

Data:

load *,

//add a new field called Tax, the values are from the csv-file from)

applymap('Map',Salesno,0) as Tax

from '$(file)' (qvd);

//store new data with same name

store  Data into '$(file)' (qvd);

//drop table

drop table Data;

//use next file

next

hope this helps

kuba_michalik
Partner
Partner

If you actually need manual data input then that's not very simple because QlikView isn't really built for data entry.

Here is one possible workaround:

1. Load the QVD

     yourtablename:

     LOAD * FROM yourfilename.qvd(qvd);

2. Store the loaded table again, but as txt:

     STORE yourtablename INTO yourfilename.txt(txt);

3. Edit the txt. It's a csv (or a tab delimited file... can't remember), so you should be able to use excel to do that.

4. Save your data, reload back into QlikView, store back into qvd if desired

There is also third party application which allows for direct edits of QVD files (Q-Eye, it's free) but whether it's something right for you you'll have to find out yourself.

hedborg
Creator
Creator

Here is a dirty solution:

http://www.etl-tools.com/products/q-eye-overview.html

They have a free tool that opens up qvd-files and allows you to modify them. No guarantee for the quality of the product, so take a backup first.

I would still recommend the correct process of Load, Modify, Store within a QlikView script though that have been proposed above my other community members.

(Personally I just use the tool to quickly view the content of QVD-files)

Kind regards

Niklas

jaimeaguilar
Partner
Partner

Hi,

For viewing QVDs, I consider QViewer a better and most robust tool. However, if you need to edit directly QVDs, then Qeye is a good choice,

regards