how can i create a custom function with specific p... - Qlik Community

khouloudgh · ‎2019-10-21

how can i create a function that have in her parameter a specifiq numbere that i will use in my sql statement

my_function( int a )

sql select * from my table where shamp = a }

endFuction

this my principe any help

Mauritz_SA · ‎2019-10-21

Hi there

Have a look at Sub Routines

Regards,

Mauritz

khouloudgh · ‎2019-10-21

i need to call my function in the editor expression to charge only the variable i need

Mauritz_SA · ‎2019-10-21

So do you mean in the front end (because then you can't use SQL)? What exactly would you like to do?

You can create a variable as well if you want to and pass it a parameter. For example:

In script:

Set CustomFunction = $1*2;

Or in front end:

Create variable called CustomFunction2 with value $1*3

Then $(CustomFunction(3)) will return 6. $(CustomFunction2(3)) will retun 9.

how can i create a custom function with specific parameter