topic AW:How to change document variable via a macro? in QlikView

How to change document variable via a macro?

Thu, 24 Jun 2010 14:20:36 GMT

How do I change the value of a document level variable via a JScript Macro?

I found out how to do it via VBScript ie.

function ThresholdSet()
ActiveDocument.Variables("MainCCYear").SetContent "=MainCCDay*22*12",true
end function

But I need to convert it to JScript.

biester — Thu, 24 Jun 2010 14:42:31 GMT

function ThresholdSet() {
var v = ActiveDocument.GetVariable("MainCCYear");
v.SetContent("=MainCCDay*22*12",true);
}

Rgds,
Joachim

Thu, 24 Jun 2010 16:56:11 GMT

Thanks, that worked like a charm.

But is there any reason you used a variable, ie. v , as opposed to just doing

ActiveDocument.Variables(

"MainCCYear").SetContent ("=MainCCDay*22*12",true); ?

Best Regards

Dieter

biester — Fri, 25 Jun 2010 08:48:56 GMT

It's just for better readability, and in case you need the object later it's shorter then always having to use "ActiveDocument.GetVariable...."

Rgds,
Joachim