topic How to define a new function? in QlikView https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149776#M27902 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>since I have a complex calculation that I reuse in charts, I would like to put into a variable the results of the calculation, but I would like to define dinamically the set of values of the fields on which to perform the calculation.</P><P>It looks like defining a new function: is it possible (perhaps using set Analysis in variable definition)?</P><P>Thanks in advance!</P><DIV class="ForumPostTitle ForumPostTitleInner"></DIV></BODY></HTML> Mon, 20 Jul 2009 19:36:43 GMT 2009-07-20T19:36:43Z How to define a new function? https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149776#M27902 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>since I have a complex calculation that I reuse in charts, I would like to put into a variable the results of the calculation, but I would like to define dinamically the set of values of the fields on which to perform the calculation.</P><P>It looks like defining a new function: is it possible (perhaps using set Analysis in variable definition)?</P><P>Thanks in advance!</P><DIV class="ForumPostTitle ForumPostTitleInner"></DIV></BODY></HTML> Mon, 20 Jul 2009 19:36:43 GMT https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149776#M27902 2009-07-20T19:36:43Z How to define a new function? https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149777#M27903 <HTML><HEAD></HEAD><BODY><P>You can define a variable as an expression that uses parameter placeholders. See the section "Dollar-Sign Expansion with Parameters" in the Ref Guide.</P><P>For example</P><P>SET myfunc= $1 + $2;</P><P>$(myfunc(3,4)) = 7</P><P>See also the attached example from the QV Cookbook.</P><P>-Rob</P></BODY></HTML> Tue, 21 Jul 2009 01:22:29 GMT https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149777#M27903 rwunderlich 2009-07-21T01:22:29Z How to define a new function? https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149778#M27904 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Rob!</P><P>It's very useful and very clear!</P><P>Roberta</P></BODY></HTML> Tue, 21 Jul 2009 16:54:07 GMT https://community.qlik.com/t5/QlikView/How-to-define-a-new-function/m-p/149778#M27904 2009-07-21T16:54:07Z