Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
After upgrading the server to version 12.20 my user defined fuctions are not working anymore.
I am getting this error in the logfile:
Error: Unexpected token: '(', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...
Any hints ?
Sounds like you're having the same issue as described in this thread:
https://community.qlik.com/message/1507014#1507014
So first step would be to try the solution suggested there. If that doesn't work, perhaps posting more information would be helpful towards debugging.
That does not help.
I made this simple script:
///$bnf off
load myfunction(a) as c, b Inline[
a,b
1,2
];
and this function with the macro editor:
function myfunction(a)
myfunction=a*-1
end function
This is working fine on the desktop and on the server with version 12.10 but not with version 12.20
I copy-pasted your code into QlikView 12.20 SR3 and it runs without problems. Macro security is set to the defaults (Safe Mode / Only Safe Mode).
Inserting ///$bnf off as the 1st line in my existing documents solves my problem.
However above example does not work anymore doing that for both desktop and server.
Strange.
So, without ///$bnf off it is not possible to use user definded functions anymore ?
Update the QV.exe Settings.ini file by adding the line EnableBnfReload=0 under the [Settings 7] tag for the default reload setting "EnableBnfReload".
By default, Settings.ini can be found in C:\%USER%\AppData\Roaming\QlikTech\QlikView
Update the QVB.exe Settings.ini by adding the line EnableBnfReload=0 under the [Settings 7] tag for the default reload setting "EnableBnfReload".
By default, the Settings.ini can be found in C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch.
Modify it to read:
[Settings 7] EnableBnfReload=0
Add the ///$bnf off tag at the top of the script (it must be within the first 50 characters of the script). Reload the script.
It is a good idea to use the ///$bnf off tag as a troubleshooting step. See if toggling this setting in the load script will cause a change in the suspect behavior.