Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Dmk
Contributor II
Contributor II

Set function adressing

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.

1 Reply
andrey_krylov
Specialist
Specialist

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

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