Section Access: multiple GROUPS for each user

[#1]

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

[vgutkovsky · Accepted solution]

Leonor,

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

Regards,

[#3]

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

[pover]

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.

[#5]

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

[pover]

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

Regards.