topic Value of variable based on SectionAccess field in QlikView

Value of variable based on SectionAccess field

wgonzalez — Sat, 16 Nov 2024 18:18:20 GMT

Hi,

I need to hide or show specific sheets or objects in a QVW, based on a field in the SectionAccess file.

This is my UserAccess table in the SectionAccess file. I plan to set a variable in the QVW, based on the value of field STAFF, but I don't know how to access such field in the QVW. The STAFF field is not part of the data model; it's only on the SA table.

ACCESS	USERID	PASSWORD	NTACCOUNT	CO	SUPVID	STAFF
USER	*	*	AM\USER1	ABC	*	Y
USER	*	*	AM\USER2	ABC	*	Y
USER	*	*	AM\USER3	ABC	*	N

Thanks.

Re: Value of variable based on SectionAccess field

Miguel_Angel_Baeyens — Wed, 29 Jul 2020 10:34:09 GMT

Fields which only belong to the Section Access table cannot be accessed or referred in the normal script. Only the reduction fields (those that do exist in the data model and establish which values can a user see) can be used.

You will need to duplicate that field somewhere in the data model (e.g.: include an "Employee" table in the data model) or use a different approach. It's difficult to say more without knowing the use case for such field.

Re: Value of variable based on SectionAccess field

wgonzalez — Fri, 07 Aug 2020 18:56:46 GMT

Thanks. I loaded a copy of the user access table into the data model and got access to the fields. I can now condition the display of specific sheets depending on the field STAFF. Thanks.