topic Re: ActiveDocument.ScrambleField "Field" Macro doesnt work in QlikView

ActiveDocument.ScrambleField "Field" Macro doesnt work

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

fkeuroglian — Sun, 06 Jul 2014 14:13:22 GMT

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

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

Anonymous — Sun, 06 Jul 2014 14:24:24 GMT

a trigger that does what?

Re: ActiveDocument.ScrambleField "Field" Macro doesnt work

Anonymous — Sun, 06 Jul 2014 14:34:26 GMT

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?