Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display fields from Section Access

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.

5 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar

Yes, like I explained above.


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar

Try using the function QVUser()

From the help file:

QVuser

Returns a string containing the name of the current QlikView user as entered in for section access.


talk is cheap, supply exceeds demand