Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

API function getlayout

Hi,

In the section access I use NTNAME. I would like to get the value of this field in a macro using ActiveDocument.GetLayout.AuthenticatedUser.

Unfortunately it appears there is a bug in QV9, this function then does not work. Is there another way to use the NTNAME in a macro ?

Thanks for your answers

1 Solution

Accepted Solutions
Not applicable
Author

Which release of QV9 are you using? I have SR5 and it seems to work fine.

Another option is to use OSUser(). OSUser() is a QlikView function and I don't think it can be used directly in a macro. You could create a variable and give it the value OSUser(). Then you could reference the value of the variable using: ActiveDocument.Variables("var").GetContent.String.

You may also be able to use something like Evaluate(OSUser()) inside the macro, but I usually just create the variable as it isn't too much hassle.

View solution in original post

2 Replies
Not applicable
Author

Which release of QV9 are you using? I have SR5 and it seems to work fine.

Another option is to use OSUser(). OSUser() is a QlikView function and I don't think it can be used directly in a macro. You could create a variable and give it the value OSUser(). Then you could reference the value of the variable using: ActiveDocument.Variables("var").GetContent.String.

You may also be able to use something like Evaluate(OSUser()) inside the macro, but I usually just create the variable as it isn't too much hassle.

Not applicable
Author

Thanks it works by upgrading to QV9 SR5. I was using QV9 SR2.

Regards Smile