topic Re: How to use a table from another QVW in QlikView

How to use a table from another QVW

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I was hoping someone could let me know whether it would be possible to use a table from another QVW.

The reason i want to do this, is that the final table created in a QVW used alot of resources and time to load, if i had to copy the very same code for another report it would be highly unnecessary. Thus i would just like to use the final table from that QVW and show it along with other information in the new one I am creating.

Is this possible? Or should i just opt to Store the final table and use the stored file to create a new table in the new QVW.

Which would be the easiest and most efficient.

Thanks in Advance.

Regards,

Re: How to use a table from another QVW

miguelbraga — Wed, 21 Sep 2016 16:20:31 GMT

Hey there,

Yes it is possible. You can make this by using a type of LOAD called Binary Load and you'll have all the data and tables from the other qvw. What you simply need to do is to drop every table that you don't require in your new qvw. Then you can link Final Table that you have spoken and continue your work.

Here is how you do a binary load from help:

=========================

Binary

The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables. Only one binary statement is allowed in the script and it can only be put as the first statement of a script.

The syntax is:

binary file

where:

file ::= [ path ] filename

Examples:

Binary customer.qvw;

Binary c:\qv\customer.qvw;

The path is the path to the file, either absolute, or relative to the .qvw file containing this script line.

========================

Best regards,

Data Architect MB

Re: How to use a table from another QVW

agomes1971 — Wed, 21 Sep 2016 16:56:14 GMT

Hi,

Syntax is Binary [Qlikview filename.qvw]

And when you go to file wizard and click on the Qlikview File by default the syntax of the file get loaded above to set expression

Ex;-

Binary [Qlikview Sales File.qvw];

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

HTH

André Gomes

Re: How to use a table from another QVW

Peter_Cammaert — Wed, 21 Sep 2016 18:09:44 GMT

You could use a BINARY LOAD in a generic QVW document to export a single table from any other QVW to a QVD.

The script (there is no User Interface to speak of) goes somewhat like this:

BINARY [$(InputQVW)];

IF Not IsNull(NoOfRows('$(TableToStore)')) THEN

STORE [$(TableToStore)] INTO [.\$(TableToStore).QVD] (qvd);

TRACE >>>> Table [$(TableToStore)] successfully written to QVD.

ELSE

TRACE >>>> Table [$(TableToStore)] couldn't be written to QVD, table does not exist.

END IF

EXIT Script;

The script uses variables that either already have a value (you can set their value in the Settings->Variable Overview) or that have their value passed via the command line.

And example command line execution might look like (I called the qvw with this script "Export.qvw"):

QV.EXE /r /vInputQVW=C:\QlikView\QVW\VeryBig.QVW /vTableToStore=FACTS Export.qvw

Useful?

Peter

Re: How to use a table from another QVW

shaikbakshu — Mon, 23 Jul 2018 07:15:09 GMT

Hi Peter,

Thank you for your sharing this script.

If it is possible to store "System Tables" object in qlikview to store another .CSV file by using Binary load?

BINARY [$(InputQVW)];