Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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
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
Hi
Thanks for this Works Perfectly !!!!
Thank you very much