topic Re: LOCK/Unlock in QlikView

LOCK/Unlock

Wed, 08 Apr 2015 10:42:40 GMT

Does lock field in triggers work without selections??

Re: LOCK/Unlock

PrashantSangle — Wed, 08 Apr 2015 11:11:09 GMT

Hi,

Can you explain your requirement in details????

Regards

Re: LOCK/Unlock

Anonymous — Wed, 08 Apr 2015 11:14:43 GMT

Hi Reena,

If you will explain what you want to achieve ..it will be helpfull to others to reply your qtn.

Re: LOCK/Unlock

Wed, 08 Apr 2015 11:20:56 GMT

hi,

Yes lock function works with the selections.

Regards

Vimlesh

Re: LOCK/Unlock

awhitfield — Wed, 08 Apr 2015 11:22:08 GMT

Hi Reena,

you would need to have a selection, the function actually Lock the Selection in the specified field, rather than locking the field.

Andy

Re: LOCK/Unlock

Wed, 08 Apr 2015 11:29:21 GMT

hi..

Thanks for your reply..

i have a requirement as follows..

when i am opening an application i have two sheets , for that based on qvuser() i need to lock and unlock fields.

if the Qvuser() is in the list of an excel file then it should show all the values of a field called NAME without any LOCK.

but if the user is not there in the list but is there in a field called MEMBER then it should lock that MEMBER name so that he cannot select other MEMBERS.

i tried with Triggers.but i am not able to achieve the condition. is there an way to do the same.

Please Suggest...

Re: LOCK/Unlock

awhitfield — Wed, 08 Apr 2015 11:46:35 GMT

Hi Reena,

you'd use section access for this to restrict the data the user can see, the attached intro document will help get you started. See Example 6

Re: LOCK/Unlock

PrashantSangle — Wed, 08 Apr 2015 12:42:38 GMT

Hi,

Yes you need Session Access for this.

Regards.

Re: LOCK/Unlock

Wed, 08 Apr 2015 12:45:17 GMT

hii..

i am already using section access in my application.. bt the thing is i need to lock selection based on loggin.. i am not able to do with conditions..

Thnk yu...

Re: LOCK/Unlock

awhitfield — Wed, 08 Apr 2015 13:42:11 GMT

You need to restrict users so they can only see there own name in the members list:

from the user based on the section access login.

First of all, fields (columns) can be hidden by the use of the system field OMIT.

Secondly, records (rows) can be hidden by linking the Section Access data with the real data: The selection

section access and section application. After user login QlikView will attempt to copy the selections in

fields in section access to any fields in section application with exactly the same field names (the field

In order for this procedure to take place, the option Initial Data Reduction Based on Section Access on the

Document Properties: Opening page must be selected.

Re: LOCK/Unlock

Anonymous — Thu, 17 Nov 2016 10:04:07 GMT

In this PDF very useful to me, thanks.

Re: LOCK/Unlock

Anonymous — Thu, 17 Nov 2016 10:07:05 GMT

am also having same scenario u find answer share with me

Re: LOCK/Unlock

Anonymous — Thu, 17 Nov 2016 10:08:56 GMT

Andrew in this PDF very useful to me really thanks

Re: LOCK/Unlock

Anonymous — Thu, 17 Nov 2016 13:29:25 GMT

i want clear requirement of Lock?