topic Re: Display fields from Section Access in QlikView

Display fields from Section Access

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Display fields from Section Access

Gysbert_Wassenaar — Wed, 18 May 2016 15:55:53 GMT

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.

Re: Display fields from Section Access

Wed, 18 May 2016 16:01:37 GMT

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.

Re: Display fields from Section Access

Gysbert_Wassenaar — Wed, 18 May 2016 16:08:26 GMT

Yes, like I explained above.

Re: Display fields from Section Access

Wed, 18 May 2016 16:18:14 GMT

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.

Re: Display fields from Section Access

Gysbert_Wassenaar — Wed, 18 May 2016 16:24:14 GMT

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.