Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rmuhammad
Contributor

How to use UDF in expression?

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

1 Solution

Accepted Solutions

Re: How to use UDF in expression?

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


talk is cheap, supply exceeds demand
2 Replies

Re: How to use UDF in expression?

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


talk is cheap, supply exceeds demand
rmuhammad
Contributor

Re: How to use UDF in expression?

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

Community Browser