Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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