Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

11 Replies
Anonymous
Not applicable
Author

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
Author

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.

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

  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
Author

Jagan,

Thanks man. Learned new stuff today.

It really works.

Best Regards,

Susvith

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

Thank you...

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this as well.

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

Regards

ASHFAQ

Bill_Britt
Former Employee
Former Employee

Hi,

This is what I use.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.