Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

binary load not working-please help.

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

1 Solution

Accepted Solutions
SunilChauhan
Champion II
Champion II

do

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

Sunil Chauhan

View solution in original post

10 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

ashfaq_haseeb
Champion III
Champion III

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

sasikanth
Master
Master

HI sahana

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

BIN.png

jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

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

jagan
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.

Not applicable
Author

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.

SunilChauhan
Champion II
Champion II

do

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

Sunil Chauhan
Not applicable
Author

Hi Sunil,

It did work with exit script.thanks