topic What is Binary Load in QlikView

What is Binary Load

Mon, 01 Dec 2014 20:51:10 GMT

Can any one explain about the Binary load and how to use it.

-Jay

Re: What is Binary Load

maxgro — Mon, 01 Dec 2014 20:56:04 GMT

Binary load is a statement you put at the beginning of a Qlik doc (.qvw) for loading the data from another .qvw (included section access data). The layout info isn't loaded.

You can only use one binary load in a .qvw

Binary load must be the first statement in a .qvw.

Re: What is Binary Load

its_anandrjs — Mon, 01 Dec 2014 21:00:56 GMT

Hi,

Binary load is the load which can be used to load data from any Qlikview file. And its advantages to get load another data model to add into existing data model of any qlikview file. And condition is its syntax can be place in the above of the SET statements see the example.

Ex:-

Binary ;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

Regards,

Anand

Re: What is Binary Load

Anonymous — Tue, 02 Dec 2014 02:46:03 GMT

Dear Jayant,

here are some details about Binary Load:

Binary Load:

Binary load is used to share the entire dtamodel between 2 QVWs. Basically, the datamodel of one QVW (Q1) is copied from RAM to disk in 0 and 1 form, for another QVW (Q2). Thus Q2 inherits entire data of Q1.

e.g. if you have a base QVW where the common metrices are designed and you want to enhance this to build more business specific dashboards, Binary load is a good option.

Also, if you want to do incremental load, the loading of high volume historical data can be done by binary mothod, to utilize its speed.

Point to be noted here is: Binary has tobe the first statement of the script.

e.g.

Binary order.qvw;

Binary c:\order.qvw;

From the HELP:

"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."

I often use binary load to separate the data model /scripting from the UI. You can easily build several applications focusing on different business groups on the same data model. So you only need to change data model at one place.

BR,

CHinna