topic Section Access for Groups in QlikView

Section Access for Groups

Tue, 14 Jan 2014 09:42:11 GMT

Hi All,

I have a table in Qlikview, Say it has some 5 fields. These fields should be displayed by default.

Users within the share point group should be able to see additional 3 fields.

How to achieve this in Qlikview ????

This is my requirement please help me with this ASAP.

Thanks in advance,

Keerthi

Re: Sharepoint Group

Tue, 14 Jan 2014 10:00:13 GMT

Best way is to use section access, you have 8 fields and default every one will be having access to 5 fields and shar point group will be having access to all 8 fields.

http://community.qlik.com/docs/DOC-1853

http://community.qlik.com/docs/DOC-2049

http://community.qlik.com/docs/DOC-5175

Re: Re: Sharepoint Group

Tue, 14 Jan 2014 13:01:12 GMT

Hi Nagaraj,

I went through the document. I tried to implement it.

Below is my section access

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,

ADMIN, admin, admin

USER, keerthi, ks

USER, soumya, ya

];

Section Application;

But i dunno how to restrict only for few fields in the table(Only for a particular object).

I have attached the QVW.

When i login with keerthi and ks as password it should display only SECTOR field with Amount.

with soumya and ya as password it should display only claim status with Amount.

Please help me with this scenario.

Regards,

Keerthi

Re: Sharepoint Group

Thu, 16 Jan 2014 06:40:42 GMT

HI All ,

Please help me with the above requirement.

Thanks in advance,

Keerthi

Re: Re: Sharepoint Group

Thu, 16 Jan 2014 07:21:22 GMT

Hi Keerthi,

Pls Find attached file .Hope it may help u

Regards,

Saurabh

Re: Re: Sharepoint Group

Thu, 16 Jan 2014 09:24:46 GMT

Thanks a lot Saurabh

Re: Sharepoint Group

Wed, 22 Jan 2014 09:50:33 GMT

Hi Saurabh,

How to do when we have a Group with some 10 users and providing access to particular group( Not to single user).

I want to give access to a group of users.

Thanks & Regards,

keerthi

Re: Sharepoint Group

Thu, 23 Jan 2014 07:00:28 GMT

Hi Saurabh,

Can we provide access for a group of users ??

Thanks & regards,

Keerthi

Re: Re: Sharepoint Group

Fri, 24 Jan 2014 11:39:26 GMT

Hi Nagaraj,

How to do when we have a Group with some 10 users and providing access to particular group( Not to single user).

I want to give access to a group of users.

Condition should be given only for Group and not the User

Attached is the QVW conditional for QVUSER. I have used QVUSER() in the condition.

Username ADMIN

Password ADMIN

Fields are conditionally show for the Users.

Please help me for the group.

Thanks & Regards,

Keerthi

Re: Section Access for Groups

Peter_Cammaert — Fri, 24 Jan 2014 12:18:29 GMT

Yes, you can assign privileges to groups if you base your user identification on AD Accounts and use the NTNAME field in section access. Values for NTNAME can be either domainname\username combinations, OR domainname\groupname. Group management is then delegated to AD however.

To hide fields for specific users, use the OMIT feature of section access. See Ch 29.6 Section Access System Fields in the QlikView Reference Manual for more information.

Best,

Peter

Re: Section Access for Groups

Fri, 24 Jan 2014 12:31:42 GMT

Thanks Peter

I tried with the NTNAME.

How to provide or conditionally hide for the particular group.

There is a inbuilt functions like QVUSER() and OSUSER(). This we can use it in hiding the data.

What about for Group of USERS ??? Help me with this

Regards,

Keerthi

Re: Section Access for Groups

Mon, 27 Jan 2014 05:10:04 GMT

Please someone help me with this

Re: Section Access for Groups

vikasmahajan — Mon, 27 Jan 2014 05:47:17 GMT

Using Section Access Users you can take currently logged user using

subfield(OsUser(),'\',-1)

and give conditions as you desire in additional while loading section access you can take 3 additional columns you want can filter with osuser() command.

Hope this will help you.

Vikas

Re: Section Access for Groups

Mon, 27 Jan 2014 07:01:29 GMT

Thanks Vikas.

I used the this function

=SubStringCount(Concat(OSUser(), '|'), 'Group Name')

It solved my problem

Thanks & Regards,

Keerthi