Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

Receiving Unknown LOAD statement error after updating Qlikview version from 12.10 to 12.2 SR6

I have a QVW that I have been running successfully for a long time.  I recently upgraded to 12.2 SR6 and now I receive an 'Unknown LOAD statement error' when I reload my script.  As far as I can tell, I did not change anything in the script to cause this and when I comment out the Join('TableName') statement in the script, in runs.  Did something change in the syntax for Join with the newer version?

Labels (2)
3 Replies
Brett_Bleess
Former Employee
Former Employee

My best hunch would be the BNF functionality is what has caught you here, here is Help link:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/Backus-Naur-fo...

I believe it is likely the quotes you are using, here is an Article that may help as well:

https://support.qlik.com/articles/000042307

This includes information on how to turn off the BNF feature, but be aware, in November 2018, you can no longer turn it off, the setting is ignored if you do set it in 12.20/November 2017...

If turning off BNF works, I am pretty sure it has to do with quotes around the table name or something along that line.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Anonymous
Not applicable

See this article. It resolved my issue immediately.

 

https://support.qlik.com/articles/000079767

 

Brett_Bleess
Former Employee
Former Employee

Cliff, check out my post and the other one, if either of them help you resolve things, be sure to click the Accept as Solution button on the one that helped the most.  Hopefully one of them will get things resolved.  If you did something else, consider documenting it and marking that as the solution.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.