Using Functions like in programming language

[SonPhan]

Hi Qlik-Experts,

Is there a way to define a function on the surface in QS that can take parameter values as input?

For example
Calc(A, B) {
return A+B}

If you now define for example Calc(3,5) as KPI 8 should be output.

Thank you for your support

[Or · Accepted solution]

On the script level, you can use Sub ... End Sub. https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptCon...

At the object (front end) level, I believe the best solution is to use a variable with $ expressions, e.g. as described here: https://community.qlik.com/t5/QlikView-App-Dev/create-custom-function-with-parameter/td-p/147066

[ArnadoSandoval]

Hi @SonPhan 

If you want to implement these function inside the load script, yes, you can, I compiling a document about variables, I already wrote and tested this section:

Multi-Parameters Function as Variables

We could define multi-parameters functions as well, we declare them with a LET in the load script, while we just create them as usual in the sheet’s variables section; in this example we consume the function at 3 different places:

1. Load script’s declaration.
2. Load script’s calculation.
3. Load script’s dynamic column.
4. UI’s Charts.

Comments:

• We declared and consume a two parameters variable function in the script.
• We did a calculation with it, printing its output to the load script log.
• We reference the variable function as a column returning a dynamic value defined by the variable function.
• We consumed the variable function in the UI as part of a Text and Image element.

Function Variables Summary

1. They are single line function.
2. They could be consumed anywhere in the application, script or user interface.
3. We haven’t seen them documented in the Qlik Help pages.

Hope this helps,

[ArnadoSandoval]

Hi @SonPhan 

This is the topic where Function Variables was explained Click Here