topic Section Access in QlikView

Section Access

varunreddy — Thu, 19 Nov 2015 12:31:56 GMT

Hi Guys,

I am trying to implement Section Access. I have divided application into

Loader - Which is used to load Data

Transformer - Transformations will be done

Application - Binary load of transformer.

My question is where should I implement section access?

Transformer or Application?

Now I have it in Transformer. But it is not working

Code Used:

Section Access;

LOAD ACCESS,
NTDOMAIN,
[NT USERID],
NAME
FROM
[$(vPath)\DQIM_AllIssues_History - Master_Post.xlsx]
(ooxml, embedded labels, table is Sheet2);

Data Set:

ACCESS	NTDOMAIN	NT USERID	NAME
ADMIN	ADMIN	ADMIN	ADMIN
ADMIN	HBEU	GB-SVC-QVService	GB-SVC-QVService
ADMIN	HBEU	HBEU-GBMUTQVSADM	HBEU-GBMUTQVSADM
ADMIN	HBEU	HBEU-GBMUTL-QVImp	HBEU-GBMUTL-QVImp
ADMIN	HBEU	HBEU-GBMUTL-QV-UAT	HBEU-GBMUTL-QV-UAT
ADMIN	HNAH	43917679	Varun Reddy Kancharla

Can any one guide me, what is going wrong?

Cheers!

Re: Section Access

swuehl — Thu, 19 Nov 2015 14:17:48 GMT

I think it's not a primary question of using section access in Transformer or Application, but to use the correct field names for section access. Please check the HELP (Section access system fields) or

Introduction to Section Access

You should use a field

NTNAME

with values like

HBEU\GB-SVC-QVService

If you are using section access in the Transformer and binary load this QVW, section access will be inherited when you open the application QVW.

Re: Section Access

Mark_Little — Thu, 19 Nov 2015 14:24:27 GMT

I agree with Swuehl point.

Just to expand further i would make sure the name are in capitals to as this does cause issues to.

HBEU\GB-SVC-QVSERVICE

I would also normally put it in the top level, but more just the way I have always approached it, right or wrongly.

Mark

Re: Section Access

syukyo_zhu — Thu, 19 Nov 2015 14:30:49 GMT

Hi,

Swuehl is correct. you should use section access in Transformer.

And don't forget SECTION Application at the end of your section access;

Re: Section Access

varunreddy — Thu, 19 Nov 2015 16:49:26 GMT

Hi Sweul,

I used NTNAME, but still it is not working.

The example I am trying:

I want the dashboard to be seen only by few users. So, I tried to apply section access to my application using NTNAME and tested. My team mate can open the file, even if his NTNAME is not listed.

Can you please guide me?