topic Re: binary load not working-please help. in QlikView

binary load not working-please help.

Wed, 25 Jun 2014 04:11:14 GMT

hi all,

Please can someone help me out with the below issue.

I am doing a binary load in my script for the first time and its not working.If you see my script,I am giving the binary load command in the 2nd tab called 'join'.but it throws error saying it an unknown statement.Please can you see my script and check if anything is wrong.

regards,

sahana

Re: binary load not working-please help.

jagan — Wed, 25 Jun 2014 04:19:10 GMT

Hi,

Binary Load is used to load only Qlikview files and Binary load should be the first statement in your qlikview file.

Binary ;

so put this in the first sheet and first line in script and make the file exists in the path.

Regards,

Jagan.

Re: binary load not working-please help.

ashfaq_haseeb — Wed, 25 Jun 2014 05:11:11 GMT

Hi Sahana,

Binary need to the first statement in your script.

Look at the attached file.

Note:

You can have only 1 binary load per application.

Regards

ASHFAQ

Re: binary load not working-please help.

sasikanth — Wed, 25 Jun 2014 05:13:05 GMT

HI sahana

Jagan is right , Binary load should be the First statement in your script , look at the picture below

Re: binary load not working-please help.

jagan — Wed, 25 Jun 2014 05:15:49 GMT

Hi,

Please check below from Qlikview help file

Binary

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:

binary file

where:

file ::= [ path ] filename

Examples:

Binary customer.qvw;

Binary c:\qv\customer.qvw;

The path is the path to the file, either absolute, or relative to the .qvw file containing this script line.

Regards,

Jagan.

Re: Re: binary load not working-please help.

Wed, 25 Jun 2014 05:35:22 GMT

Hi Jagan,

Thanks for the response.I followed the way whatever you mentioned,now the error doesn't come but the application gets hanged during debug/reload after its almost completes .Hence the last sheet chart values doesn't appear as it doesn't get the dimention:counterparty1 which has to come from the binary loaded file.

Both these apps work well when done separately.

Can you please guide how to proceed???

regards,

Sahana

Re: Re: binary load not working-please help.

jagan — Wed, 25 Jun 2014 05:53:26 GMT

Hi,

Can you attach sample file, so that it would be easier to debug.

Regards,

Jagan.

Re: Re: Re: binary load not working-please help.

Wed, 25 Jun 2014 06:01:11 GMT

sure.

The file is attached in which data comes for the backtesting and backtesting details when we select the delivery details selections.this comes from the same script.

But the last sheet charts 'yusufrep' doesn't come since its from the binary load.'

the file just freezes .eg during debug it shows script finished but when I click on close it gets hanged until I do an alt+ctr+del end task.

please help.

Re: binary load not working-please help.

SunilChauhan — Wed, 25 Jun 2014 06:15:58 GMT

exit script; after binary and check 3rd tab is coming or not

if coming then there might be concatenation or something else happening after binary.

you need to check them

Re: binary load not working-please help.

Wed, 25 Jun 2014 06:36:19 GMT

Hi Sunil,

It did work with exit script.thanks

Re: binary load not working-please help.

ashfaq_haseeb — Wed, 25 Jun 2014 07:18:16 GMT

Hi sara leslie

This is one of them I didn't receive points.

There are many I have participated.

Regards

ASHFAQ