Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
Creator
Creator

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
Gysbert_Wassenaar

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
Gysbert_Wassenaar

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
Creator
Creator
Author

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