topic Re: QVD files in QlikView

QVD files

Tue, 21 Oct 2014 06:46:41 GMT

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

Re: QVD files

alexandros17 — Tue, 21 Oct 2014 06:49:07 GMT

The only way you have is loading the qvd, modify, update it and store it again.

Hope it helps

Re: QVD files

Anonymous — Tue, 21 Oct 2014 06:51:45 GMT

Deepak,

You can load your qvd files, modify the loaded data if you require, and then you can store it as a qvd file again in case you will need it for next loading.

Marc.

Re: QVD files

Tue, 21 Oct 2014 06:54:39 GMT

i dont have any other source for data. just the QVD files.

can we modify the QVD file??? and how do we do that???

or else can we convert it into any other format(say csv or xlsx)

Re: QVD files

Tue, 21 Oct 2014 07:00:27 GMT

how do i modify it??.. i need to add a column

Re: QVD files

alexandros17 — Tue, 21 Oct 2014 07:01:05 GMT

Simply

MyQvd:

Load * from xxx.qvd;

At this point you can modify it as any other table.

You can save the resulting table as qvd again or as csv

Re: QVD files

Anonymous — Tue, 21 Oct 2014 07:07:11 GMT

the info you have to add is in another qvd, external sorce or is it a fixed value or calculation from field you have....?

Re: QVD files

Tue, 21 Oct 2014 07:09:55 GMT

its just another column which i have in excel sheet

Re: QVD files

martinpohl — Tue, 21 Oct 2014 07:11:55 GMT

try this:

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

trace $(file);

Data:

load *

//here add your new fields

from '$(file)' (qvd);

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

drop table Data;

If the new field contains data from another file join it or use applymap

Regards

Re: QVD files

Tue, 21 Oct 2014 07:16:42 GMT

thanks for that but i m new to qlikview and i m not able to understand that..

could you please break it for me

Re: QVD files

martinpohl — Tue, 21 Oct 2014 07:22:48 GMT

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

hope this helps

Re: QVD files

kuba_michalik — Tue, 21 Oct 2014 07:32:31 GMT

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.

Re: QVD files

Anonymous — Tue, 21 Oct 2014 07:36:36 GMT

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

Re: QVD files

jaimeaguilar — Tue, 21 Oct 2014 16:59:04 GMT

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