topic Re: Optional Argument in Sub or Function in QlikView

Optional Argument in Sub or Function

Tue, 22 May 2012 19:32:15 GMT

Using QV10 SR3. Can you create a Function or Sub with an optional argument? For example, can I create a Function like:

Function AddEmUp (a, b, optional c)

AddEmUp = a + b + c

End Function

Here, the argument c is optional...so it works if I pass it two or three arguments.

swuehl — Tue, 22 May 2012 19:52:31 GMT

You can create a function variable (dollar sign expansion with arguments), e.g.

Define in the script:

Set vDateDiff = if(len($2)=0, today(), $2) - $1;

Then you can call vDateDiff with one or two arguments (second argument defaults to today()):

=$(vDateDiff('1/1/2012'))

=$(vDateDiff('1/1/2012','2/1/2012'))

IAMDV — Tue, 22 May 2012 20:04:16 GMT

Also, please read this post :

Thanks,