Optional Argument in Sub or Function - Qlik Community

Report Inappropriate Content · ‎2012-05-22

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 · ‎2012-05-22

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 · ‎2012-05-22

Also, please read this post :

Thanks,

DV