Set function adressing

Dmk — Thu, 25 Oct 2018 13:40:10 GMT

Hello

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,

$1)),($2));

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.

Re: Set function adressing

andrey_krylov — Thu, 25 Oct 2018 16:58:47 GMT

Hi Damian. It seems that the cause is in the second parameter. I'm not sure, but try this

=$(=$(extNum(myData, expMoney))

topic Set function adressing in QlikView

Set function adressing

Re: Set function adressing