topic Re: User-defined functions inside load script in QlikView

User-defined functions inside load script

Tue, 22 Oct 2013 16:21:57 GMT

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 — Tue, 22 Oct 2013 16:24:20 GMT

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