User-defined functions inside load script

[#1]

Hi, Is this possible in QlikView?  I'd like to define a function that does some simple math

define addTheseForMe(int a, int b):
     return a+b;

MyTable:
LOAD if(ColA = x AND colB = y, addTheseForMe(ColA,ColY),null())
RESIDENT some_table;

[Aurelien_Martinez · Accepted solution]

Hi,

You can do:

SET addTheseForMe = $1 + $2;

MyTable:

LOAD if(ColA = x AND colB = y, $(addTheseForMe(ColA,ColY)),null()) 

RESIDENT some_table;

Regards,

Aurélien