Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
HI sahana
Jagan is right , Binary load should be the First statement in your script , look at the picture below
Hi,
Please check below from Qlikview help file
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.
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
Hi,
Can you attach sample file, so that it would be easier to debug.
Regards,
Jagan.
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.
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
Hi Sunil,
It did work with exit script.thanks