topic Re: How to use UDF in expression? in QlikView

How to use UDF in expression?

rmuhammad — Thu, 03 Dec 2015 16:05:10 GMT

How do I use UDF in expression? is there a work around?

e.g. Look at the spell number post (link provided) has a UDF function which translate $$ into words. I need to apply that on Total and thought i can simply use it in expression however I am getting error and research on forum leading me to believe it is not possible. It works fine in load script but I cant get totals precalculated.

any suggestion? please help

link to UDF function

Spell Number

Re: How to use UDF in expression?

Gysbert_Wassenaar — Thu, 03 Dec 2015 18:52:58 GMT

There exists a hidden easter egg setting AllowMacroFunctionsInExpressions that allows you to use functions created in the macro editor in expressions. Easter egg menu: Menu --> Help --> About QlikView --> right click on qlik-symbol in bottom left corner

Re: How to use UDF in expression?

rmuhammad — Fri, 04 Dec 2015 14:17:08 GMT

OMG ! Gysbert how did you even find this menu?
Thanks Gysbert it worked just the way I want it.