Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Hi all,

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

plz provide steps to follow

Thanks

Sudhanshu shrivas

1 Solution

Accepted Solutions
Not applicable

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

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

6 Replies
Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

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.

Not applicable

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

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

Community Browser