topic Re: Hierarchy wise sheet access. in QlikView

Hierarchy wise sheet access.

Tue, 06 Nov 2012 13:23:31 GMT

Hello everyone,

I need to provide access to sheets according to users in hierarchy.

For example: CM>ZM>RM>SM>UM

SM should be able to access sheets of UM under it and so on.

Please help regarding the same.

Regards,

Utsav

Re: Hierarchy wise sheet access.

Tue, 06 Nov 2012 14:40:50 GMT

You can build an access table like this:

Then under Sheet Properties > General > Show Sheet > Conditional you can use something like [CM]=1 for the sheet CM and so on.

Re: Hierarchy wise sheet access.

Wed, 07 Nov 2012 06:12:36 GMT

HI rebeccad,

what condition should i use in the conditional field?? nothing seems to be working with this.

Regards,

Utsav

Re: Hierarchy wise sheet access.

Thu, 08 Nov 2012 14:11:03 GMT

Say you have your security table (like the one I put above) as a file in Excel. Load it into your script. The USER column should be a list of users (you can see yours if you type this into your text object: =OSUser()

Then put a 1 for the sheets each user should see. Then in Sheet Properties > General > Show Sheet > Conditional, you will type [CM]=1. Let me know if you are still confused.