topic Section Access: multiple GROUPS for each user in QlikView

Section Access: multiple GROUPS for each user

Mon, 15 Nov 2010 22:52:30 GMT

HI everyone,

I'm here this time because of the Section Access.

In the Qv application I've a menu, that according to the bottom pressed it'll enable some tabs. I need to restrict the accesss to those tabs throught the mentioned bottoms.

So, I've a lists of users with the set of bottoms they can have access.

I've put the condition: GROUP='IT' and it works fine if the user have just one group configured, if have more than one, I need to select the group in a list box .

How can I do to the botton gets the groups with selecting it in the list box?? thxs in advance

Section Access: multiple GROUPS for each user

vgutkovsky — Mon, 15 Nov 2010 23:18:45 GMT

Leonor,

You can do something like the following: fieldindex('GROUP','IT')>0

Regards,

Section Access: multiple GROUPS for each user

Wed, 17 Nov 2010 15:30:28 GMT

Hi Vlad, thaks for your response.

At the enabled condition of my bottom I´ve put what you recommend me: fieldindex('GROUP','B1')>0 But the bottom it's disabled.

So, I´ve two doubts: 1. wich others values can return de function fieldindex and what do they mean? I assume >0 is returned when the value B1 were found in the field GROUP, but what abput when the returned value is 0?

2. Because of the permissions of the users could be for several bottoms, the user USERA will appear as many times as different bottoms he can have access. Eg: USERA, B1; USERA, B3; USERA, B5.

Why do u think is this happening?

Thxs in advance, Leonor

Section Access: multiple GROUPS for each user

pover — Wed, 17 Nov 2010 16:47:04 GMT

Leonor,

What Vlad suggested works fine. See the attached the attached example (enter with the ntnames in your Excel).

FieldIndex according to QlikView Help returns a number which represents the order in which it was loaded. If the the value is not found it returns 0.

Regards.

Section Access: multiple GROUPS for each user

Wed, 17 Nov 2010 17:21:36 GMT

Hi Karl,

As the example I attached shown, the GROUP has alphanumeric values. I change it to just numbers and it works.

I dont know if is "normal".

About your attached file, i could'nt opened it because ask for user and password.

thxs in advance

Section Access: multiple GROUPS for each user

pover — Wed, 17 Nov 2010 17:40:25 GMT

Open my example with the user LFerrebuz or HPerez and it shouldn't ask for password.

Regards.