Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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))