Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

3 Replies
fkeuroglian
Partner - Master
Partner - Master

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

Anonymous
Not applicable
Author

a trigger that does what?

Anonymous
Not applicable
Author

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?