topic Re: How to set variable as read-only via macro or in script? in QlikView

How to set variable as read-only via macro or in script?

hugmarcel — Tue, 26 Jan 2016 11:36:57 GMT

Is it possible to mark a variable as read-only, either via macro or in script?

I have about 10'000 variables in Document properties -> Variables, and do not like to scroll throuth all of them to set the attribute manually.

Thx - Marcel

marcus_sommer — Tue, 26 Jan 2016 12:01:13 GMT

See this adjusted example from APIGuide.qvw for read only:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

prop.ConstraintsFlag = 4 'read only

v.SetProperties prop

and this here is an example how to loop through the variables:

set vars = ActiveDocument.GetVariableDescriptions

for i = 0 to vars.Count - 1

set v = vars.Item(i)

msgbox(v.IsConfig)

- Marcus

HirisH_V7 — Tue, 26 Jan 2016 12:11:30 GMT

Hi ,

like this,

alternatively add this to your macro code,

set macroVariable = ActiveDocument.GetVariable("yourVariableName")

then use marcroVariable.GetContent.String to retrieve the variable's contents

HTH,

Hirish

hugmarcel — Tue, 26 Jan 2016 12:26:22 GMT

Great! Thank you!