Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))