topic Re: when do we prefer Binary load in QlikView

when do we prefer Binary load

Sun, 19 Jul 2015 06:08:53 GMT

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.

Re: when do we prefer Binary load

Kushal_Chawda — Sun, 19 Jul 2015 06:22:39 GMT

May be this will help you

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

Re: when do we prefer Binary load

maxgro — Sun, 19 Jul 2015 06:39:37 GMT

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)

Re: when do we prefer Binary load

Anonymous — Sun, 19 Jul 2015 10:13:13 GMT

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

Re: when do we prefer Binary load

qlikviewwizard — Sun, 19 Jul 2015 14:50:12 GMT

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

Re: when do we prefer Binary load

paulyeo11 — Sat, 05 Sep 2015 03:06:23 GMT

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

Re: when do we prefer Binary load

qlikviewwizard — Sat, 05 Sep 2015 04:29:08 GMT

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.

Re: when do we prefer Binary load

Anonymous — Sat, 05 Sep 2015 05:59:03 GMT

Hi Srinivas,

Have a look:

Re: Binary Load

Hope it helps!!

Re: when do we prefer Binary load

Anonymous — Sat, 05 Sep 2015 11:38:19 GMT

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

Re: when do we prefer Binary load

Anonymous — Sun, 06 Sep 2015 06:21:43 GMT

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