when do we prefer Binary load

[#1]

Hi All,

I know binary load concept that we can use one qvw file into another qvw but only one qvw file that too the script will be place on top of SET variables statements.

My question is ..when do we do binary load and where the impact would be in application?

Please help me on this.. thank you.

[Kushal_Chawda]

May be this will help you

https://community.qlik.com/thread/96240

[maxgro]

In some cases it is preferable to separate the development of the database Qlik from the development of the user interface.

For example a developer creates the .qvw with only the Qlik database (without the user interface) and makes it available to power users or developers that use the same common model to create many different user interfaces (dashboards). The user interface developers need a limited knowledge of Qlik scripting as they only use the binary load statement.

Actually, you can also do the same thing with the QVD (instead of binary load) but using the binary load is very simple for UI developers / power users, just one statement, binary load.

EDIT

Another useful feature of the binary load is you can decide who has access to the .qvw (the .qvw will be read with binary load) adding to the .qvw the section access (because the section access is loaded with the binary load)

[Anonymous]

Hi Srinivas ,

Mostly in every qlikview application binary load is used.

Every qlik application is divided into three parts

1.We load all the data and convert into qvd's

2.we develop our datamodel.

3.Presentation layer (Charts,list boxes).

In the presentation layer we use binaryload to call our datamodel instead of creating datamodel again in presentation layer

Thanks

[qlikviewwizard]

When you need to load the qlikview file directly. You can use binary load.

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.

Binary customer.qvw;

Courtesy- MayilVahanan

[paulyeo11]

Hi Rgv

you mention about 3 steps , may i know your step 1  read the raw data into QV is using 1 QVW file , and step 2 when you develop the data model , are you using the same QVW file ? and for step 3 i am aware that it is using another QVW file read the binary load of file from Step 2.

in conclusion , what i want to know your 3 step approach using how many QVW file ?

Hope you can share with me.

Paul

[qlikviewwizard]

Hi,

We can use the binary load to use another qvw file's data into other.

Example:

Sales_Details.qvw is using Employee_Details.qvw.

Later we can add another tables to Sales_Details.qvw.

Hope this will helpful to you. Thank you.

[Anonymous]

Hi Srinivas,

Have a look:

Re: Binary Load

Hope it helps!!

[Anonymous]

Hi Srinivas,

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

Binary load is more secure, since your business logic is not in the Presentation layer (Dashboard), nobody can access or edit your code.

Binary load is often used to separate the data model /scripting from the Presentation layer. You can easily build several Dashboards/Applications focusing on different areas of business on the same data model.

It will be efficient and easy to maintain as all data is at one place.only we need to copy the Data model with all the data into presentation layer,that is Final QVW for each business area.

Regards

Neetha

[Anonymous]

Hi Paul,

Step 1 : In the first qvw we will connect to database and fetch data (writing sql queries etc..) and store them into qvds.

Step2: Create  another qvw file and load all the qvds and prepares  datamodel.

Step3: Create another file and loads the datamodel using binary load .

In this approach 3 qvw's are used.

Thanks