Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.