Error msg :- Unknown statement Binary "c:\users\paul yeo\dropbox\qlik_sap\production\sap_qvd_v018.qv

[paulyeo11]

Hi All

I have QV Doc ,when i do reload it does not have any error. I control E , to edit script.
I click on button = QlikView File
I click on the QVW which is working fine which working fine , it auto generate the below script :-
Binary "c:\users\paul yeo\dropbox\qlik_sap\production\sap_qvd_v018.qvw";

When i do a reload script , i get below error :-

Unknown statement
Binary "c:\users\paul yeo\dropbox\qlik_sap\production\sap_qvd_v018.qvw"

May i know where go wrong?

Paul Yeo

[Arthur_Fong]

Why do you need to binary load this qvw?
Comment out the binary if not required.

[paulyeo11]

Hi Fong

The reasons i load binary is because it auto generate script as below :-

Binary "c:\users\paul yeo\dropbox\qlik_sap\development_qv\sap_qvd\sap_qvd_v018.qvw";

When i try to remove Binary word , it still get error :-

 "c:\users\paul yeo\dropbox\qlik_sap\development_qv\sap_qvd\sap_qvd_v018.qvw";

When i try to remove " it still get error :-

c:\users\paul yeo\dropbox\qlik_sap\development_qv\sap_qvd\sap_qvd_v018.qvw;

Any idea where go wrong ?

Paul

[Frank_Hartmann · Accepted solution]

Your Binary Statement has to be the very first statement in script, like this:

Binary [c:\users\admin\desktop\123.qvw];

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

LOAD [Column 1], 
     [Column 2],
     left([Column 2],1)&'0000'&right([Column 2],3) as NewField
FROM ............

if i put the Binary Statement to another Row than the first one then i will get the same Unkown Statement error like you!

hope this helps

[Arthur_Fong]

Also note that you can only binary load from one qvw to another.

Refer to qlik help for more info.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...