topic Custom Functions in QlikView https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238338#M89240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Qlikview calculates variables for each row in the pivot table.</P><P>What can be done is :</P><P>Set a variable (e.g. vMyExpression) with the formula to evaluate, using chart functions.</P><P>In the pivot table, write "=$(vMyExpression)" in the expression.</P><P>add a input box with the variable, in order to debug the formula</P><P>I prefer this method to a macro, when it is applicable</P><P>Pierre.</P></BODY></HTML> Sun, 14 Feb 2010 15:06:38 GMT pdumas 2010-02-14T15:06:38Z Custom Functions https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238337#M89239 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Thanks</P></BODY></HTML> Sun, 14 Feb 2010 00:56:44 GMT https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238337#M89239 alan_grn 2010-02-14T00:56:44Z Custom Functions https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238338#M89240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Qlikview calculates variables for each row in the pivot table.</P><P>What can be done is :</P><P>Set a variable (e.g. vMyExpression) with the formula to evaluate, using chart functions.</P><P>In the pivot table, write "=$(vMyExpression)" in the expression.</P><P>add a input box with the variable, in order to debug the formula</P><P>I prefer this method to a macro, when it is applicable</P><P>Pierre.</P></BODY></HTML> Sun, 14 Feb 2010 15:06:38 GMT https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238338#M89240 pdumas 2010-02-14T15:06:38Z Custom Functions https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238339#M89241 <HTML><HEAD></HEAD><BODY><P>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).</P><P>If your calculation is fairly complex, I'd recommend pre-calculating it in the load script. Otherwise, look into using $-sign expansions.</P></BODY></HTML> Sun, 14 Feb 2010 17:05:21 GMT https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238339#M89241 Oleg_Troyansky 2010-02-14T17:05:21Z Custom Functions https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238340#M89242 <HTML><HEAD></HEAD><BODY><H2>Can you please upload a sample qvw file to load pre calculated complex calculation.</H2></BODY></HTML> Wed, 16 Feb 2011 11:50:38 GMT https://community.qlik.com/t5/QlikView/Custom-Functions/m-p/238340#M89242 2011-02-16T11:50:38Z