topic Re: How to Implement Section Access in QlikView

How to Implement Section Access

Tue, 28 Apr 2015 07:15:12 GMT

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.

Re: How to Implement Section Access

datanibbler — Tue, 28 Apr 2015 07:36:17 GMT

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

Re: How to Implement Section Access

Tue, 28 Apr 2015 07:42:03 GMT

Hi,

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

Thanks

Re: How to Implement Section Access

datanibbler — Tue, 28 Apr 2015 07:44:18 GMT

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!

Re: How to Implement Section Access

Tue, 28 Apr 2015 07:47:36 GMT

Hi,

Users will access the Model through Browser.

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

Thanks.

Re: How to Implement Section Access

hariprasadqv — Tue, 28 Apr 2015 08:03:14 GMT

Hi,

Fallow the images they may help you.

Re: How to Implement Section Access

datanibbler — Tue, 28 Apr 2015 08:05:13 GMT

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

Re: How to Implement Section Access

Tue, 28 Apr 2015 12:44:45 GMT

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

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 12:52:15 GMT

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.

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:03:40 GMT

Hi Michael,

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

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

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

on my conditions it hides the Tabs

Please Assist.

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 13:25:54 GMT

You don't need to do anything in the script at all.

It hides the tabs - that means it works

It hides the tabs from you because you're are not allowing yourself to see the tabs. Add your own Windows ID in each condition:

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

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

...

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:31:11 GMT

where do i find MyWindowsID

Regards

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:32:47 GMT

Hi,

My App has almost 10 Sheets but i want to test only on two first.

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 13:36:06 GMT

Your windows id is the login you type (or select) to open Windows. Maybe TPaulos or something like that.

To test with one or two tabs - just don't use "conditional" show sheet on all other tabs.

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:44:32 GMT

Hi,

still gives Problems, it hides and when i close the Model and re-open it doesn't require Passwords and Opening- Initial Data Reduction is Unchecked.

Regards.

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 13:47:28 GMT

you need to close your qlikview ...then again open it . and try to open your qvw.

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 13:47:49 GMT

Why do you need password? If your only purpose is to hide tabs for certain users, you don't need section access, hence no password.

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:50:30 GMT

Hi,

How are they gonna access the Tabs, they're Hidden?

Because i'm acting as Admin and Also User before Handing the Model to Users.

Re: How to Implement Section Access

Anonymous — Tue, 28 Apr 2015 13:56:05 GMT

My last response to this discussion, sorry...

I thought the whole purpose of this is to allow users to see some tabs and don't see the other tabs. If a tab is hidden from a user, user doesn't have access to it.

To test as a different user - you have to open Windows as this user. There is no other way, sorry. If you always open Windows as yourself, you see what is allowed to you, that is probably everything.

Re: How to Implement Section Access

Tue, 28 Apr 2015 13:58:11 GMT

Ish,

any clue how can this be Solved?

Thanks