topic Use more than 9 parameters in User Defined Functions in QlikView

Use more than 9 parameters in User Defined Functions

guillermo_welch — Fri, 24 Nov 2017 09:38:41 GMT

I'm trying to generate a user defined function with more than 9 parameters, but when qlikview reaches $10, it substitutes $1 for the first parameter, and leaves the 0 behind it.

The UDF is:

SET UDF =

If($2 > 0, $1 / $2 * $3 / ($(_AUXUDF($2, $3, $5, $6, $8, $9, $11, $12))), 0) +

If($5 > 0, $4 / $5 * $6 / ($(_AUXUDF($2, $3, $5, $6, $8, $9, $11, $12))), 0) +

If($8 > 0, $7 / $8 * $9 / ($(_AUXUDF($2, $3, $5, $6, $8, $9, $11, $12))), 0) +

If($11 > 0, $10 / $11 * $12 / ($(_AUXUDF($2, $3, $5, $6, $8, $9, $11, $12))), 0);

¿Can somebody point me in the right direction?

Re: Use more than 9 parameters in User Defined Functions

petter — Fri, 24 Nov 2017 11:59:13 GMT

The documentation doesn't mention whether it supports more than $1 to $9.

$0 actually gives you the last parameter

By testing I have discovered that it will not work with anything except 0..9 as the character after $.

Re: Use more than 9 parameters in User Defined Functions

guillermo_welch — Fri, 24 Nov 2017 14:57:24 GMT

I have arrived to the same conclusion. I managed to join several parameters into a string to save parameters.