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

How do I create a qvd file from a qvw

Hi

I am pretty new to qlikview.  we had a 3rd party company who created our builds for us, but nowwe are going do this ourselves

The 3rd party company would send us a qvw file with all our data processed.

I was wondering how i would extract the data from the qvw to a qvd file.

example

In the qvw file there is a table called transactions (which is the one i am after)

Is it possible to run some script of some sort to extract only this table from the qvw and save it as a qvd so that i can load the qvd in my own build.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Indeed, I'd do that doing a binary load of the QVW you get in a separate file, and then user a STORE command, as follows:

Binary ;

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

// The name of the table "Transactions" needs to be exactly the same as in the other file, case sensitive

STORE Transactions INTO C:\Transactions.qvd (qvd);

Hope that helps.

Miguel

View solution in original post

5 Replies
swuehl
MVP
MVP

You could create a new qvw, with first statement a binary load of your existing qvw.

Then store all tables you are interested in into qvds.

Please look into BINARY and STORE in the Help file.

Hope this helps,

Stefan

Miguel_Angel_Baeyens

Hi,

Indeed, I'd do that doing a binary load of the QVW you get in a separate file, and then user a STORE command, as follows:

Binary ;

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

// The name of the table "Transactions" needs to be exactly the same as in the other file, case sensitive

STORE Transactions INTO C:\Transactions.qvd (qvd);

Hope that helps.

Miguel

Not applicable
Author

Dear Miguel,

As you said in the above, when I try to store a qvd, I am getting a error of

"Binary Load is not allowed on 'E:\Trend.qvw'"

Regards

Joe

Miguel_Angel_Baeyens

Hi Joe,

That's a setting the original developer can set in the Settings menu, Document Properties, Opening tab, "Prohibit Binary Load", very usual when the development has been carried out by different companies that want to keep their knowledge on the file and prevent others to open the script or see the data model structure. That setting can only be changed by the original developer.

Regards.

Miguel

Not applicable
Author

Hi

Thanks for this Works Perfectly !!!!

Thank you very much