topic Re: "functions" available in load script in QlikView

"functions" available in load script

Wed, 28 Dec 2011 11:20:10 GMT

Hi all,

I know I can create subs in qlikview, but can you also create a function in the script?

e.g

function CheckIfFileExists(filename)

bla bla

end function

next to this: it seems qlikview only accepts subs with at least one parameter? (I am now using a dummy value as parameter)

PS: I don't want to use macro's for this (unless it is the only way. I want to have all coding in the script)

Thanks for your replies!

"functions" available in load script

gandalfgray — Wed, 28 Dec 2011 11:27:48 GMT

There are no "functions" in QV, just "subs"

You should be able to have subs without parameters. (I have)

You just define it without a parenthesis after if you do not want parameters

/gg

"functions" available in load script

Wed, 28 Dec 2011 11:58:55 GMT

No, I don't believe you can have VB functions in load scripts. You can however do loops - for example, while, for etc. which you might find useful

Re: "functions" available in load script

rbecher — Wed, 28 Dec 2011 12:39:01 GMT

At least you can have Subs with parameters..

It is possible to use VBScript or JScript functions in the load script but it slows down the load process and the load statement cannot be spread into parallel threads.

- Ralf

Re: "functions" available in load script

Wed, 28 Dec 2011 13:55:59 GMT

Hi Thank you.

I don’t need VB/java functions. I would just like to have the “function” à a sub that returns a value

Is that also not possible? The ref. manual only refers to subs.

Thanks!

Re: "functions" available in load script

Wed, 28 Dec 2011 13:57:11 GMT

A thanks, that is the answer. But it is not possible to provide a return value then?

Re: "functions" available in load script

gandalfgray — Wed, 28 Dec 2011 14:17:21 GMT

Not a proper "return value", however all variables used in the sub are also available from the outside, so you can assign a variable a value in the sub which are accessible from the calling environment.

Re: "functions" available in load script

rbecher — Wed, 28 Dec 2011 14:40:23 GMT

You could use variables as functions for simple tasks like this:

SET FileExists = if(len(FileSize($1)) > 0, -1, 0);

LET vExists = $(FileExists('dir\filename.ext');

// from Rob Wunderlich´s Qlikview Components (QVC)

- Ralf