Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Ive been trying to include in a text box fields that belong to the section access.
For example, apart from the normal fields in the section access, I also have Name and Surname. I want to create a text box including the user's Name and his Surname.
Is there anyway I can achieve this?
Thank you for your help.
The Section Access table is not a normal data table and will not be included in the data model. If you want it in the data model then you need to load it again as a regular table.
Yes I was aware of that, but is there any way i can load just those two fields out of the SA and then put it in the textbox to show the full name from the user.
Yes, like I explained above.
The problem is that it will load all names, and I wanted the current user's name in the text box. So if another user would use the same document, his name would be displayed without making any extra load. Im having difficulties in finding solution for that.
Try using the function QVUser()
From the help file:
Returns a string containing the name of the current QlikView user as entered in for section access.