Lock selection from Data Load Editor

[YanivZi]

I want to lock selection the way i do manually by pressing on the lock icon to specific users.

When i am on the Load Editor i will use OSUser() to get userId and if its don't match condition to lock the selection, like area='1' (otherwise show all, unlock all) on the sheet for him. so he can see only area 1

[rubenmarin]

Hi, you can use section access to restrict the data each user can see, take a look at the help page: https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...

Also demonstrations in video: https://www.youtube.com/watch?v=7Va5DvWmT6A

[YanivZi]

Thank for replying, 

today when i  click on area '1' i see in top tabs my selection (area 1) and then i click on the lock icon.

I want the function that do that. like app.field('area').select('1').lock()

I will use this from data load editor on specific condition. 

[rubenmarin · Accepted solution]

Hi, you can't apply selections or lock fields until the reload has finished, but you can assign a vlue to a variable while reloading, and use a default bookmark that opens a sheet, and an action on that sheet that locks the field based on the variable value.

Note that the lock can be removed by users, if you wan't to restrict data to users the best way is to use section access.