topic How to provide Document level restriction with section access ? in QlikView

How to provide Document level restriction with section access ?

Fri, 03 Jul 2015 11:56:55 GMT

Hello All,

My requirement is to restrict different Qlikview Dashboard to several user within organization.

I want to achieve it by using section access not with Windows securities.

My concern is to achieve it by using only single Excel & single sheet.By Multiple excel or Multiple sheet may be it is achievable but that approach will not acceptable in my case.

I have tried like below but condition returns false while execution & 'Access denied error will occur'

Excel Data like below,

ACCESS,NTNAME,DOCUMENTNAME

ADMIN,ABC,TEST_NEW.QVW

ADMIN,PQR,TEST_OLD.QVW

section access;

LOAD

ACCESS,

NTNAME,

DOCUMENTNAME

From source.xls where DOCUMENTNAME=Documentname();

section application;

(Without Section access condition will restrict field-values but on access-point application is visible.

Any idea by how we can achieve it,

Thanks

Re: How to provide Document level restriction with section access ?

Gysbert_Wassenaar — Fri, 03 Jul 2015 12:18:26 GMT

You will have to add a section access table to each document and in each document you need to enable the Filter AccessPoint Document List Based on Section Access option on the Server tab on the Document Properties window of the document.

Obviously, the above only applies to document accessed through the Access Point of a Qlikview Server installation. And documents accessed that way will always only have USER level access. ADMIN level access won't be available.

Re: How to provide Document level restriction with section access ?

jonathandienst — Fri, 03 Jul 2015 12:28:55 GMT

Don't include the DOCUMENTNAME in the SA load:

LOAD

ACCESS,

NTNAME,

DOCUMENTNAME

From source.xls where DOCUMENTNAME=Documentname();

where WildMatch(DOCUMENTNAME, Documentname())

Re: How to provide Document level restriction with section access ?

Fri, 03 Jul 2015 13:15:39 GMT

Thanks jonathan,

By your suggested changes things working perfectly at my end.

Still not understood what's wrong in my script is it because format issue.If possible please guide.

Thanks & regards,

Harshal

Re: How to provide Document level restriction with section access ?

Fri, 03 Jul 2015 13:23:24 GMT

Thanks a lot Gysbert for suggested settings & your time