topic What is binary load and how it is implemented ?? in QlikView

What is binary load and how it is implemented ??

nikhilgarg — Tue, 23 Sep 2014 11:43:17 GMT

HEy,

WHat is Binary Load and how it is done ??

Thanks

Re: What is binary load and how it is implemented ??

ashfaq_haseeb — Tue, 23 Sep 2014 11:45:37 GMT

Search in community

Reference manual

Do Practice

Binary

explain binary load and inline load in Qlikview???

Regards

ASHFAQ

Re: What is binary load and how it is implemented ??

rajeshvaswani77 — Tue, 23 Sep 2014 11:47:44 GMT

Hi Nikhil,

For binary load do this

binary <qvw filwe name>

the files should be in the same folder

used to import the full data model as it is from another dashboard.

In cases where you do not want to do the full reload and you need a copy of the same dashboard.

Note it will not load the layout information and the variables.

thanks,

Rajesh Vaswani

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 05:42:19 GMT

HEy,

You mean to say that binary load is only used in case if i am making new application and i need to load data from some other qlikview app. Is it so ??

If yes then let say:

I have disaster qlikview app. Now i created another app say disaster1 and i want to load data from disaster app in edit script tab.

How can i do this ?? Can you tell me the syntax ??

Thanks

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 05:42:37 GMT

HEy,

You mean to say that binary load is only used in case if i am making new application and i need to load data from some other qlikview app. Is it so ??

If yes then let say:

I have disaster qlikview app. Now i created another app say disaster1 and i want to load data from disaster app in edit script tab.

How can i do this ?? Can you tell me the syntax ??

Thanks

Re: Re: What is binary load and how it is implemented ??

ashfaq_haseeb — Wed, 24 Sep 2014 05:49:07 GMT

Hi yes your understanding is correct.

Few considerations:

1) There will be only one binary load per application

2) You will not get script from disaster to disaster1, You just get data model.

Have a look at attached applications.

Make sure to close threads.

Regards

ASHFAQ

Re: What is binary load and how it is implemented ??

Wed, 24 Sep 2014 05:55:37 GMT

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.The syntax is:

Examples:

Binary c:\qv\customer.qvw;

Generally Binary Load is used to hide the scripts from Users. First one Qlikview file with all the scripts required for the reports are created and then binary load this into another file by using

Script -> Qlikview File -> Select the Qlikview file created earlier.

You can load only one qlikview file by using Binary load. By using this Binary Load Scripts are hidden from users.

Its much faster.

After binary load statement, you can add extra scripts below it

For First Question answer :

see it is not like that what ur asking in ur question ..... i just explained what is binary load and where we ll use and why ll use

for ur second question i have give the answer please go through that ..... and select the appropriate answer as a correct answer and close the thread

Re: Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 05:58:46 GMT

Hey ,

Thanks but i have used following script but it is giving error. I am writing this script in disaster1.qvw to load data from disaster.qvw.

BINARY "C:\Users\nikhil.garg\Desktop\disaster.qvw" ;

What to do ??

Thanks.

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 06:00:52 GMT

Hey ,

Thanks but i have used following script but it is giving error. I am writing this script in disaster1.qvw to load data from disaster.qvw.

BINARY "C:\Users\nikhil.garg\Desktop\disaster.qvw" ;

What to do ??

Thanks.

Re: What is binary load and how it is implemented ??

rajeshvaswani77 — Wed, 24 Sep 2014 06:02:29 GMT

Just Binary and qvw name. Have both in same folder.

thanks,

Rajesh Vaswani

Re: Re: What is binary load and how it is implemented ??

ashfaq_haseeb — Wed, 24 Sep 2014 06:02:30 GMT

Go to edit script--> Click on QlikView file as highlighted in image.

Now locate your file

Let me know if that worked

Regards

ASHFAQ

Re: Re: What is binary load and how it is implemented ??

ashfaq_haseeb — Wed, 24 Sep 2014 06:04:09 GMT

Try with this

Binary [C:\Users\nikhil.garg\Desktop\disaster.qvw];

Regards

ASHFAQ

Re: What is binary load and how it is implemented ??

Wed, 24 Sep 2014 06:08:16 GMT

loading entire application through single statement is binary load

syntax:

binary filename.qvw;

it should be the first statement of the script.

Editscript>Qlikviewfile( under tablefiles)> select application which u want load .

Re: What is binary load and how it is implemented ??

Wed, 24 Sep 2014 06:09:35 GMT

Hi , u please check ur disaster qvw app Document Properties check for the prohibit binary ... if it marked as right check mark please make it as unchecked and try the above process ... u ll get it now ......

and if u load ur disaster file by using Qlikview file option u ll get script like this

Binary ;

and please close the thread

Re: What is binary load and how it is implemented ??

Wed, 24 Sep 2014 06:10:42 GMT

e option deniki antara vadiki

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 06:13:34 GMT

HEy,

It still does work.

I created new app. Go to Edit Script->Add tab->Select Qlikview File->

Binary [..\..\users\nikhil.garg\desktop\disaster1.qvw];

But it shows error: Unknown statement.

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 06:16:02 GMT

HEy,

I checked the option Prohibit binary load but still same error: Unknown statement

Re: What is binary load and how it is implemented ??

er_mohit — Wed, 24 Sep 2014 06:16:50 GMT

To inherit the data of one application to another. use binary load

For this Take example

You have made modelling in Test1.qvw save it . make sure in

Documnet Properties--> Opening tab --> there's uncheck Prohibit Binary load . if not then do it.

Now create new application Say Test2

In Go to script (ctrl+e)

Below Click on the button Qlikview file. then browse your application i.e Test1.qvw then ok

Reload the Test2 application and save it

Re: What is binary load and how it is implemented ??

Wed, 24 Sep 2014 06:17:40 GMT

see dont create any new tab ,just put cursor on all above set statements while loading application ,because binary should be the first statement in script .

binary filename.qvw;

set ...

set..

Re: What is binary load and how it is implemented ??

nikhilgarg — Wed, 24 Sep 2014 06:19:54 GMT

HEy ,

THanks. It works.