Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (2)
1 Solution

Accepted Solutions

Re: How do I create a qvd file from a qvw

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

5 Replies
MVP
MVP

How do I create a qvd file from a qvw

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

Re: How do I create a qvd file from a qvw

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

Re: How do I create a qvd file from a qvw

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

Re: How do I create a qvd file from a qvw

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

How do I create a qvd file from a qvw

Hi

Thanks for this Works Perfectly !!!!

Thank you very much

Community Browser