topic Re: Section access with multiple values not working in QlikView

Section access with multiple values not working

sifatnabil — Fri, 05 Feb 2016 10:54:47 GMT

Hi all,

I have a section access table in Excel like this:

ACCESS	NTNAME	REGION	REGIONLOG	REGIONX	PRODUCT	PRODUCTX
ADMIN	ICAP\QVSERVICE	*	*	*	*	*
ADMIN	GLOBAL\SIFAT	EMEA	EMEA	EMEA	ASIA	EMEA - ASIA
ADMIN	GLOBAL\SIFAT	EMEA	EMEA	EMEA	CNH	EMEA - FWDS
ADMIN	GLOBAL\SIFAT	EMEA	EMEA	EMEA	ASIA	EMEA - FWDS
ADMIN	GLOBAL\BISHOP	*	*	*	*	*
ADMIN	GLOBAL\BISHOP-A	*	*	*	*	*

None of these fields intersect. For example, the PRODUCT=CNH is under REGION/REGIONLOG/REGIONX='EMEA'

The section access works fully for my normal account GLOBAL\SIFAT (and I've tested by changing my product and seeing the change work), however, for the other users, they only sees 3 products instead of all 7.

Why would section access work for my user but not the other users? Does it have something to do with * ? The issue seems to be that no one can see all products despite having * against them.

Re: Section access with multiple values not working

stigchel — Fri, 05 Feb 2016 11:05:50 GMT

The * in section access means all listed values in the section access table. You can e.g. add a dummy user with a line for each product to make sure all products are listed in the access table

Re: Section access with multiple values not working

MK_QSL — Fri, 05 Feb 2016 11:38:26 GMT

This one is for your reference.

Data Reduction Using Multiple Fields

Re: Section access with multiple values not working

Peter_Cammaert — Fri, 05 Feb 2016 11:41:36 GMT

Correct.

Section Access will not go looking in other related fields in Section Application for any additional field values. A * refers only to the values listed in the SA table.