topic Need help in providing sheet level section access through section access mangement in QlikView

Need help in providing sheet level section access through section access mangement

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

Need help in providing sheet level section access through section access mangement

plz provide steps to follow

Thanks

Sudhanshu shrivas

Re: Need help in providing sheet level section access through Publisher

Tue, 23 Dec 2014 13:08:33 GMT

Hi Sudhanshu,

It is possible, find below an example how the section access should look like,

Section Access;

LOAD * INLINE [

NTNAME, ACCESS, USERID, PASSWORD, DEPARTMENT, SHEETS1, SHEETS2

XX, USER, *, *, DEPARTMENT1, 1, 0

XX, USER, *, *, DEPARTMENT2, 0, 1

];

In sheet properties, make the Show Sheet as conditional with the condition as sum(SHEETS1)=1 for those who need to see the sheet1, and son on.

Regards,

Sajeevan

Re: Need help in providing sheet level section access through section access mangement

Tue, 23 Dec 2014 13:13:19 GMT

hi,

thanks for your reply

I need to do this through section access management tab of qv server.

as I will be taking the link of auth table to generate my section access.

need to know how I can give sheet level section access using servers section access management tab.

thanks

Re: Need help in providing sheet level section access through section access mangement

Tue, 23 Dec 2014 13:25:14 GMT

I think this can only be done through the document section access

Re: Need help in providing sheet level section access through section access mangement

Tue, 23 Dec 2014 13:33:25 GMT

Hi all,

I have section access through section access management tab of server.

I am planning to create a excel for sheet level access an add it to the script of my doc under the place where I have taken section access auth file.

Hope this works

any other suggestions will be helpful

Thanks

Sudhanshu Shrivas

Re: Need help in providing sheet level section access through section access mangement

Anonymous — Tue, 23 Dec 2014 18:18:07 GMT

The Section Access Management tab in the QMC is merely a way of storing the data needed for Section Access, so you can use it store the data that Sajeevan Govindan has suggested earlier in his Inline Load. You can then simply load it from the url in the script.

Then do what he suggested for the conditional Show Sheet.

Re: Need help in providing sheet level section access through section access mangement

Mon, 29 Dec 2014 08:20:41 GMT

Hi,

Thanks for your reply.

I did as you advise and it works now.

sheet level section access cant be given through section access management tab.

applied section access using another excel.

Thanks

Sudhanshu Shrivas