Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain about the Binary load and how to use it.
-Jay
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
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.
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
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