topic Re: lock selections for just one user in QlikView

lock selections for just one user

kostiskampouris — Tue, 03 Apr 2018 11:09:45 GMT

Hello everybody.

I have a document with many sheets and users.My goal is to add a new user who can only see one of the sheets (sheet1 )

which after searching I have seen that it is possible(haven't tried it yet).

My problem is that in the sheet1 there are informations about many countries and I want the user to be able to see only informations about his country.

Is there a way to lock the country's listbox with a value but only for the specific user?(I need the other users to be able to navigate through all possible countries and the new user to be able to see only his country) .

Thank you in advance

Re: lock selections for just one user

sunny_talwar — Tue, 03 Apr 2018 11:54:56 GMT

Why don't you use section access here?

Introduction to Section Access

Re: lock selections for just one user

kostiskampouris — Fri, 13 Apr 2018 11:01:46 GMT

Hello Sunny,once again you gave me the right asnwer and I am really greatfull

After a lot reading about section access I created many examples and all worked fine.

I have a final problem regarding the initial document.The country field as is loaded is an integer

1,2,3 etc .

in the script I use :

Country:

LOAD * INLINE "

country,REGION

1, GREECE

2, CYPRUS

3, ROMANIA

4, NICOSIA (FRANCH)

5, BULGARIA

so I can "translate" numbers into names.

In the section access I use :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, ROMANIA

USER, USER2, U2, BULGARIA

USER, USER3, U3, GREECE

USER, USER4, U4, CYPRUS

USER, USER5, U5, *

];

Section Application;

But when I open the document,all users can see all countries.

Can you see what I am missing here?

Re: lock selections for just one user

jonathandienst — Fri, 13 Apr 2018 11:08:03 GMT

Is the [country] field linked to the rest of the data mode?

have you enabled Strict Exclusion (Document Properties | Opening)?

Also no USER will be able to see NICOSIA (FRANCH) as it is not explicitly listed to any user.

Re: lock selections for just one user

sunny_talwar — Fri, 13 Apr 2018 11:08:34 GMT

May be try this

Country:

LOAD country,

Upper(REGION) as REGION;

LOAD * INLINE "

country,REGION

1, GREECE

2, CYPRUS

3, ROMANIA

4, NICOSIA (FRANCH)

5, BULGARIA

so I can "translate" numbers into names.

In the section access I use :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, ROMANIA

USER, USER2, U2, BULGARIA

USER, USER3, U3, GREECE

USER, USER4, U4, CYPRUS

USER, USER5, U5, *

];

Section Application;

Re: lock selections for just one user

kostiskampouris — Fri, 13 Apr 2018 11:14:09 GMT

Thank you for you imidiate answer.

It was the Strict Exclusion that forgot.

Thank you again