Discussion Board for collaboration on QlikView Scripting.
I have problem with adressing to my marker ($2) in function SET
SET extNumA = NUM(if(fabs($1) > 1000000, $1/1000000,
if(fabs($1) > 1000, $1/1000,
SET extNum = chr(36)&'(extNumA($1,$2))&'& chr(36) & '(extNumB($1))';
Out there in the visualisation I have function like this:=$(=$(extNum(myData,$(expMoney))) where ($1) represents myData, and $2 is expMoney
I have a feeling this is a good code and I dont have any issues during compilation but there is no return of this (it shows "-"). Maybe someone can elabore on this.
Hi Damian. It seems that the cause is in the second parameter. I'm not sure, but try this