topic Re: Section access permissions in qlikview? in QlikView

Section access permissions in qlikview?

Tue, 03 Feb 2015 12:03:10 GMT

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

Re: Section access permissions in qlikview?

jonasheisterkam — Tue, 03 Feb 2015 12:10:10 GMT

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.

Re: Section access permissions in qlikview?

jonasheisterkam — Tue, 03 Feb 2015 12:13:01 GMT

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;

Re: Section access permissions in qlikview?

Tue, 03 Feb 2015 12:54:03 GMT

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