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: 
JuMo
Creator
Creator

Using Dollar-sign expansions with multiparameters functions

Hello all

I have created a simple Variable called Test: 2*$1

And I use it a a User Defined Function in my expressions:

= $(Test(3))

Resul: 6

 

However if instead of 3 as a parameter I use a multifontion paramater, it stops to work, for exemple:

= $(Test(Floor(3.88 ,0.1)))

The error I have is:

Error in expression: ')' expected

= 2*Floor(3.88

I imagine the ',' in the Floor function is the source of the error

 

What can I do ?

 

Note

= $(Test(Floor(3.88)))

Works perfectly and resul: 6

 

 

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

It's expecting a value as parameter, whereas you are providing an expression. What you can do instead is to make the expression evaluated beforehand, and try like:
$(Test($(=Floor(3.88 ,0.1))))

View solution in original post

2 Replies
tresesco
MVP
MVP

It's expecting a value as parameter, whereas you are providing an expression. What you can do instead is to make the expression evaluated beforehand, and try like:
$(Test($(=Floor(3.88 ,0.1))))

JuMo
Creator
Creator
Author

Many thanks