Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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
MVP & Luminary
MVP & Luminary

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

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

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

View solution in original post

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.