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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Implement Section Access

Hi,

how do i implement Simple Section Access for 3 Users within Qlikview Tabs.

Document with 3 Tabs:

Admin to Access all Tabs

User1 to access Tab1 and Tab 2 only

User2 to access Tab 3 only

User3 to access Tab 4 only

Thanks.

20 Replies
datanibbler
Champion
Champion

Hi,

if you just want to make the tabs visible to certain users only (if your users don't have the ability to view the script or add fields to the GUI and thus see data they're not supposed to)

=> Then you can do without SA. Just use the OSUSER() function to identify which user is logged on and set visibility_conditions for the tabs.

That of course depends on how your users access the apps - if they access them via the Browser, they cannot do much beyond selecting anyway, so that will be all right.

If they have the client, you have to use SA to mark them as "user" (as opposed to "admin") and take from them the ability to open the script and to add new objects.

HTH

Not applicable
Author

Hi,

I Don't Understand what you mean, please explain with Examples.

Thanks

datanibbler
Champion
Champion

Hi Thabiso,

well, it all depends on exactly what you want to do and how your implementation looks like:

- How do your users access QlikView (Browser or Client_software)?

- What do you want to do (only restrict the access to the tabs)?

Answer me those first, please, then my answer will be much shorter.

Thanks!

Not applicable
Author

Hi,

Users will access the Model through Browser.

Restrict those Users from Accessing other Tabs only access those Tabs i gave rights to.

Thanks.

hariprasadqv
Creator III
Creator III

Hi,

Fallow the images they may help you.

1.PNG

2.PNG

datanibbler
Champion
Champion

Hi Thabiso,

then it's quite easy: In the Browser the users cannot do much beyond selecting and clicking - they cannot access the script by default and they cannot add any fields that you haven't made available - so you are the gateway to pass if users want anything new.

That limits your "ToDo-list" to adding visibility_conditions to your sheets using the OSUSER() functionality. Just try it out in a textbox so you know the syntax.

And in case you have the tabs (on the top) deactivated and you have navigation buttons, apply the same conditions to those so the users don't see buttons that don't do anything - that's always a bit irritating.

HTH

Not applicable
Author

Hi,


Below is the Script i used and it dosen't work, it Hides Tabs


Section Access;

LOAD * INLINE [

    ACCESS, USERID, GROUP

    ADMIN, ADMIN1, GROUP1

    USER, USER1, GROUP2

    USER, USER2, GROUP3

];

Section Application;

LOAD * INLINE [

    GROUP, Sheets, flag

    GROUP1,SH01, 1

    GROUP1,SH02, 0

    GROUP2,SH01, 0

    GROUP2,SH02, 1

    GROUP3,SH01, 1

    GROUP3,SH02, 1

];

Sheet properties

sum(SH01)>=1


Urgent Response will be Appreciated.



Thanks

Anonymous
Not applicable
Author

Section access is not needed in this case.  As stated above, all you need is the conditional show of the sheets, and condition is based on the current user.  See sheet properties, tab General, check "Conditional" and enter condition.

For Tabs 1 and 2:

wildmatch(OSUser(), '*User1*')

for tab3

wildmatch(OSUser(), '*User2*')

for tab4

wildmatch(OSUser(), '*User3*')

If there is a tab available for user 1 and user 2:

wildmatch(OSUser(), '*User1*', '*User2*')

In all examples, "user N" is Windows ID of the user.

Not applicable
Author

Hi Michael,

do i have to add Hidden Script, because when i add

wildmatch(OSUser(), '*User1*')

or

wildmatch(OSUser(), '*User2*')


on my conditions it hides the Tabs


Please Assist.