Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access

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

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

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'

View solution in original post

23 Replies
cesaraccardi
Specialist
Specialist

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

Not applicable
Author

Hi Cesar,

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

Thanks!

cesaraccardi
Specialist
Specialist

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?

Not applicable
Author

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

Not applicable
Author

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

I dont see it in your script.

cesaraccardi
Specialist
Specialist

I'm putting in the tab show condition.

Not applicable
Author

And where is the tab show condition located?

Thanks

cesaraccardi
Specialist
Specialist

At the Sheet properties, first tab.

Not applicable
Author

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?