topic Re: Using Macro's in table expressions (definition) in QlikView

Using Macro's in table expressions (definition)

Wed, 25 Jul 2012 09:13:23 GMT

Hi,

I have written a Macro in the editor module:

function one(param1)

one = param1 + param1

end function

Now I am calling the function 'one(3)' in a table column as expression. However the result that is being returned is ' - '.

Why does is not just return 6? Do I have to do something else?

I folllowed some tutorials on macro's but they only use it for 'onAction' events.

Regards.

forte — Wed, 25 Jul 2012 11:43:09 GMT

Hi ,

You can only use defined macro's on your Load Script, not even on expressions. As you have told you can also call them on triggers.

Best Regards

Wed, 25 Jul 2012 11:51:47 GMT

Hi,

That is pity. It would be nice to have vbScript/Jscript working also in expressions.

Tnx for the answer.

Best Regards