topic Re: Lock some fields containing a word in QlikView

Lock some fields containing a word

Thu, 20 Dec 2012 09:09:13 GMT

Hi,

I'm trying to lock all the fields containing a word 'TEST'.

For example i want at the open of the document, lock the fields abcTEST, abcTESTde, ...

As there are a lot of fields, i would like to know an alternative to lock every field ono per one in parameter->document parameter on tab trigger

thanks

flipside — Thu, 20 Dec 2012 09:13:00 GMT

Have you tried setting up a bookmark with include layout state and applying that on a trigger instead.

flipside

Thu, 20 Dec 2012 09:25:45 GMT

Aren't there a way to loop on all the fields in VB script and ook if the field contain 'TEST' for finally lock the fields

thanks

Thu, 20 Dec 2012 10:29:31 GMT

I found a solution with a macro that i shoot at the open of the document.

Here is the macro

sub lockCCAFields

set flddescs = ActiveDocument.GetFieldDescriptions

for i = 0 to flddescs.count() -1

fdesc = flddescs(i)

if InStr(1,fdesc.Name,"TEST")>0 then

ActiveDocument.getField(fdesc.Name).Lock

end if

end sub