Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jt0803aa
New Contributor III

ActiveDocument.ScrambleField "Field" Macro doesnt work

Hello

i had a requirement to scramble a certain field if the Var XX= 0.

i triggered this macro on the " OnOpen "

IF ActiveDocument.Variables("XX").GetContent.String ="0" Then

  ActiveDocument.ScrambleField "Field",false

End If

i accessed the model with a user that was configured with XX= 0 and the result was that  sometimes it opened up  the model with a scrambled field and sometimes it didn't  ????

any ideas on how i can scramble a field upon a certain condition ????

Thanks a lot

J

Tags (4)
3 Replies
Partner
Partner

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

Hi, you test in the acces point or in the desktop?

you can do this not using a macro , using a trigger could be easier and it works ok in the desktop and the acces point

go to

document properties - trigger

Good luck

Fernando

jt0803aa
New Contributor III

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

a trigger that does what?

jt0803aa
New Contributor III

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

i read some more in the community and i found out that there is a problem with the

OnOpen Document Event Trigger it doesn't work in AJAX

any ideas on how to scramble a field  according to your NT user privileges?