# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Use more than 9 parameters in User Defined Functions

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?

1 Solution

Accepted Solutions
MVP

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 \$.

2 Replies
MVP

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 \$.

Contributor II

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