Parameterized variables (optional parameter)

Mon, 03 Feb 2014 17:47:27 GMT

I want to create a parameterized variable to does something like this:

sum($1*$2)

however, I want the second parameter to be optional, so if $2 was not provided, it would just be sum($1). I tried using an if(isnull($2)) with two separate functions, but that seems to evaluate the field passed in $2 and provided very wierd answers when i didn't pass a value in the second parameter. Is there a QV function to test if a parameter was passed?

Re: Parameterized variables (optional parameter)

Aurelien_Martinez — Mon, 03 Feb 2014 17:55:18 GMT

Hi,

You can try :

Sum($1*alt($2,1))

Best,

Aurélien

topic Re: Parameterized variables (optional parameter) in QlikView

Parameterized variables (optional parameter)

Re: Parameterized variables (optional parameter)