topic How do I create a qvd file from a qvw in QlikView

How do I create a qvd file from a qvw

Thu, 05 Jan 2012 11:35:04 GMT

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.

How do I create a qvd file from a qvw

swuehl — Thu, 05 Jan 2012 11:43:47 GMT

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

Miguel_Angel_Baeyens — Thu, 05 Jan 2012 11:45:42 GMT

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

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

Thu, 05 Jan 2012 12:58:10 GMT

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

Miguel_Angel_Baeyens — Thu, 05 Jan 2012 13:19:25 GMT

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

How do I create a qvd file from a qvw

Thu, 05 Jan 2012 14:00:56 GMT

Thanks for this Works Perfectly !!!!

Thank you very much