Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

+Create Qvd from existing qvw file

Hi . I have an old qvw file which imported data from databases that have been removed now. Now I have to make updates on the qvw file but the reload will not work now since the database is gone. I was wondering if there's a way of storing data from the existing qvw into a qvd file so that I can reload it from there again after making changes to the qvw file.

Cheers,

Varun

1 Solution

Accepted Solutions
MVP
MVP

Re: +Create Qvd from existing qvw file

Hi,

Try like this

Create a new Qlikview file and do Binary load the old file and put below script to generate the QVDs for the existing tables in the datamodel

BINARY FileName.qvw;

FOR vCount = 0 to NoOfTables()-1

     LET vTableName = TableName($(vCount));

     STORE $(vTableName) INTO $(vTableName).qvd (qvd);

NEXT vCount

The above script will create the qvds for each table in the datamodel.

You can also check this link below

Storing all tables in Qlikview file to QVD

Hope this helps you.

Regards,

Jagan.

11 Replies
praveenavelagap
Contributor III

Re: +Create Qvd from existing qvw file

you can create table box in front end for each and every table and export to excel . here you go, You will have the data you want ..

Not applicable

Re: +Create Qvd from existing qvw file

Thanks Praveena. That is possible to do but there are a lot of tables with multiple columns in each so it would be a time consuming process to add all the columns as expressions. Thanks for the suggestion though.

MVP
MVP

Re: +Create Qvd from existing qvw file

Hi,

Try like this

Create a new Qlikview file and do Binary load the old file and put below script to generate the QVDs for the existing tables in the datamodel

BINARY FileName.qvw;

FOR vCount = 0 to NoOfTables()-1

     LET vTableName = TableName($(vCount));

     STORE $(vTableName) INTO $(vTableName).qvd (qvd);

NEXT vCount

The above script will create the qvds for each table in the datamodel.

You can also check this link below

Storing all tables in Qlikview file to QVD

Hope this helps you.

Regards,

Jagan.

skusuma1991
Contributor

Re: +Create Qvd from existing qvw file

  Hi,

The same issue i am also facing i am trying to load by using binary but the QVW which i have is disabled for the binary load is there any solution for extracting data from it.

jagan

Regards

Sagar

Not applicable

Re: +Create Qvd from existing qvw file

Jagan,

Thanks man. Learned new stuff today.

It really works.

Best Regards,

Susvith

MVP
MVP

Re: +Create Qvd from existing qvw file

Hi,

Open the old QVW document and follow this to remove Binary Load option

Document Properties -> Opening -> Uncheck Prohibit Binary Load option

Hope this helps you.

Regards,

Jagan.

skusuma1991
Contributor

Re: +Create Qvd from existing qvw file

Thank you...

Re: +Create Qvd from existing qvw file

Hi,

Check this as well.

https://community.qlik.com/docs/DOC-6991

Regards

ASHFAQ

Employee
Employee

Re: +Create Qvd from existing qvw file

Hi,

This is what I use.

Bill

Community Browser