topic Re: VBScript Function Call from Script (QV12.20) in QlikView

VBScript Function Call from Script (QV12.20)

martinsuske — Mon, 04 Dec 2017 16:53:12 GMT

Hi all,

I have a problem calling VBScript functions in my load script.

Using the example code from the qlik help I get the same error:

Script:

let MaxPop=VBin('Max population in millions :');

Syntax error

Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

let MaxPop=VBin>>>>>>(<<<<<<'Max population in millions :')

I'm using QlikView Desktop 12.20 (Nov 2017)

Any ideas?

Best regards,

Martin

Re: VBScript Function Call from Script (QV12.20)

eldro — Tue, 05 Dec 2017 09:51:25 GMT

I experience the same problem with 12.20. Sorry for not helping out with a solution but maybe it helps to push the topic a bit further for this common use case. I tried to replace (..) with {..}, [..] and eventually rewriting the line to call VBin() but nothing helps. The only hint that Qlikview sees VBin as a VBScript function is the syntax highlighting deminishes as soon as the function is renamed to something like VBin2 in the VBScript editor but not in the QV script.

Maybe we miss out a new security setting?

Re: VBScript Function Call from Script (QV12.20)

Anonymous — Tue, 05 Dec 2017 10:43:11 GMT

HI, I have the same issue:

function:

function Somma(x, y) {

Somma=a+b

}

script:

IF Somma(2, 3) = 5THEN

TRACE("OK");

ELSE

TRACE("KO");

ENDIF

It doesn't work: Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS'...

Can someone help us?

Re: VBScript Function Call from Script (QV12.20)

martinsuske — Wed, 06 Dec 2017 08:30:18 GMT

I just found this thread Executing Jscript function during load statement

which suggests turning off the new BNF mode by adding ///$bnf off as first line of the script.

Works for me.

Re: VBScript Function Call from Script (QV12.20)

eldro — Wed, 06 Dec 2017 09:35:25 GMT

Thanks, that does the trick!

Just a hint: >///$bnf off< belongs to the very first line of the Qlikview script (I tried the module script at first ..)

alesanti‌: The signature of your Somma function uses x,y but returns a,b -> took some time to figure that out

Re: VBScript Function Call from Script (QV12.20)

Anonymous — Wed, 06 Dec 2017 11:13:47 GMT

It works also for me!

Thank you Martin!

Yes Eric, my mistake, I write down quickly.