How to create Java Script Function and passing array from load script
I often use a function that usually shortnes my loading proccess
This is step by step guide that explain how to create and using Java Script function in edit script load data.
In the example below the function will return the serching number if is exist in an array list, else, the smaller closet number returned , else, if not exist smaller closer number the big closet returned.
Set enable to call function from load script
HELP>About Qlikview>right click on QV icon
Change AllowMacroFunctionslnExpression to "1"
Then open Edit Modul (ctrl+m) and past the following script