topic Section Access in QlikView

Section Access

Tue, 17 Jul 2012 19:13:24 GMT

Can you perform section access for tabs? So if I was authenticating users by their AD login information, can I say what tabs within a document they can see?

Thanks

Re: Section Access

cesaraccardi — Tue, 17 Jul 2012 20:19:12 GMT

Hi,

I've attached a document with Section Access control, here is an idea for tab controlling based on user access:

Users/Passwords:

Cesar / 1234

Pedro / 1234

Re: Section Access

Tue, 17 Jul 2012 20:45:55 GMT

Hi Cesar,

Can you explain how you added the view-specific security in your document?

Thanks!

Re: Section Access

cesaraccardi — Tue, 17 Jul 2012 20:52:54 GMT

Hi, for this I'm using the "Initial Data Reduction based on Section Access", this configuration is made under the Document Properties / Opening tab. By using this, when a user opens the document all the unrelated values (other user access) are erased... also the tabs are defined to be conditionally shown with the expression Only(Access) = 'X',making the other tabs hidden. Got it?

Re: Section Access

Tue, 17 Jul 2012 20:59:22 GMT

Okay, I will have to try that. Thank you!

Re: Section Access

Wed, 18 Jul 2012 13:25:39 GMT

Where are you putting the "Only(Access)='x'?

I dont see it in your script.

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 14:36:28 GMT

I'm putting in the tab show condition.

Re: Section Access

Wed, 18 Jul 2012 17:31:07 GMT

And where is the tab show condition located?

Thanks

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 17:34:58 GMT

At the Sheet properties, first tab.

Re: Section Access

Wed, 18 Jul 2012 17:49:03 GMT

When I put that in, my tab disappears. So how do I get it back? I need to put an 'X' underneath that tab name in the application access portion of the script?

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 17:52:44 GMT

The 'X' is an arbitrary character I put to define that the user has access to the particular tab, you must define all the access in the script. If you want to get it back you can access the sheet properties through the document properties and clean the expression.

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 17:57:17 GMT

Note that the "Access" in the expression

Only(Access) = 'X'

is a field matching the sheet and it will change between the tabs. i.e. if you have a sheet called Dashboard and another called Analysis you may have 2 different columns in your access table like "Dashboard" and "Analysis" and the conditional shown expressions will be Only(Dashboard) = 'X' and Only(Analysis) = 'X'

Got it?

Re: Section Access

Wed, 18 Jul 2012 18:23:23 GMT

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, JOHN.DOE

USER. JANE.DOE

USER. JOE.SMITH

]

;

So after this point, how would I go about giving the access to my "Applications","User", and "Manager" tabs?

John.Doe (being the ADMIN) should see everything

Jane.Doe should see Application and User tabs

Joe.Smith should see only the Managers tabs

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 18:30:54 GMT

Ok, first of all you need a common field between the Section Access and the Section Application... this way you can use the configuration "Initial Data Reduction based on Section Access", the field could be the NTNAME for example. In the Section Application you'll have your access table, so the script may look like this:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, JOHN.DOE

USER. JANE.DOE

USER. JOE.SMITH

];

Section Application;

ACCESS:

LOAD * INLINE [

NTNAME, APPLICATIONS,USER,MANAGER

JOHN.DOE,X,X,X

JANE.DOE,X,X,

JOE.SMITH,,,X

];

Finally, you put the expressions on the sheets show conditions:

Only(APPLICATIONS)='X' , Only(USER)='X' and Only(MANAGER)='X'

Re: Section Access

Wed, 18 Jul 2012 20:30:36 GMT

I got it to work. Thank you.

Isnt there an inherit problem with this though. Cant the user go in and remove the conditional statement? Or is there a setting on the document properties to not allow them to see the tab properties?

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 20:35:35 GMT

If the user has access to change the sheet properties it can disable the hide conditions. You can disable the Sheet Properties for users in the Document Properties / Security tab.

Regards,

Cesar

Re: Section Access

Wed, 18 Jul 2012 20:37:51 GMT

Thats what I thought.

I looked in the Security tab and I see the "Access Document Properties" option but not the sheet properties. Which one is it?

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 20:39:56 GMT

I think its "Access Tabrow Properties".

Re: Section Access

Wed, 18 Jul 2012 20:40:57 GMT

I found a "Access sheet properties" check box in the "Sheet properties" of each sheet on the security tab, not the document properties.

Could that be what I'm looking for?

Re: Section Access

cesaraccardi — Wed, 18 Jul 2012 20:42:27 GMT

I'm not sure but I think thats it... Can you test it with a user access and tell the results?