Custom Functions

[alan_grn]

What is the best way to write / use cutom functions in QLikview? I need to create a function which will then use data from the tabel as an input. I have created a VBScript function, but do not know how to get it to be used as an expression.

Thanks

[pdumas]

Hi,

Qlikview calculates variables for each row in the pivot table.

What can be done is :

Set a variable (e.g. vMyExpression) with the formula to evaluate, using chart functions.

In the pivot table, write "=$(vMyExpression)" in the expression.

add a input box with the variable, in order to debug the formula

I prefer this method to a macro, when it is applicable

Pierre.

[Oleg_Troyansky]

VBScript functions can be used in the load script, even though it makes the load very slow (if you are loading a lot of data).

If your calculation is fairly complex, I'd recommend pre-calculating it in the load script. Otherwise, look into using $-sign expansions.

[#4]

Can you please upload a sample qvw file to load pre calculated complex calculation.