Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access permissions in qlikview?

Hi Friends,

i have four years of data in my data base like 2006, 2007, 2008, 2009. And we have two users like A, B.

My question, i have to give access to two user's alternativly like A access to 2006 & 2008 and B access to 2007 & 2009.

How it is possible?

could you please provide the code.

Thanks & Regards

Ramesh

3 Replies
jonasheisterkam
Partner - Creator III
Partner - Creator III

Use in skript insert section acces inline table with NTName @ the column Year and then enter all kombinations. Last you enter a new row with the serviceuser and no filter in the Year.

Make a copy befor you enter a section access, it is possible to close it vor everyone if the content of the table is not correct.

jonasheisterkam
Partner - Creator III
Partner - Creator III

section access;

Load * inline [

ACCESS, NTNAME, YEAR

ADMIN, DOMAIN\SERVICEUSER1

USER, DOMAIN\USER2,2008

USER, DOMAIN\USER2,2006

USER, DOMAIN\USER2,2007

USER, DOMAIN\USER2,2009

];

section application;

Not applicable
Author

Hi Rameshchetu,

you will find the community has a number of good resources on section access, just use the search option and you will see plenty to help, see a few examples below.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

http://community.qlik.com/docs/DOC-7327

Hope that helps

Joe