Nested user defined function

Thu, 15 Dec 2011 01:24:51 GMT

I'm creating a user defined function as below:

SET GetUSDRate =

if((not IsNull($1)) and (len($1) > 0) and (IsNum($1)) and ($1 <> 0),$1,if((not IsNull($2)) and (len($2) > 0) and (IsNum($2)) and ($2 <> 0),$2,$3));

Basically I pass in 3 rates and it returns the first non-null non-zero rate it finds. What I want to do is make one of the parameters I pass in the result of a different function.

So my call looks something like:

$(GetUSDRate(0,[Override USD Rate],[FX Currency USD Rate]))

What I want to know is how can I replace the first parameter of zero with the result of a function, for example:

$(GetUSDRate( $(NewFunction(param1)),[Override USD Rate],[FX Currency USD Rate]))

I've tried something like above but it doesn't work. I can't use variables as this is a set based operation and the result of "NewFunction" is based on data specific to each row.

I'm new to QV so I might be going about this completely the wrong way.

Hope this makes sense. Any help appreciated.

Thanks

Gregg.

topic Nested user defined function in QlikView

Nested user defined function