Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
I Don't Understand what you mean, please explain with Examples.
Thanks
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!
Hi,
Users will access the Model through Browser.
Restrict those Users from Accessing other Tabs only access those Tabs i gave rights to.
Thanks.
Hi,
Fallow the images they may help you.
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
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
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.
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.