Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

Lock field on sheet trigger not working

I have set variable, select in field and lock field Onactivate sheet trigger, on sheet A,

But if I go to sheet B do some selections, then go back to sheet A the lock field does not show in my selections criteria.

Is this normal?

Or have I set something I shouldn't have. Please can someone guide me.


Thanks

regards

Mina


will post a sample when I can.

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

probably the "select in field" doesn't work, because if the value exists and you select in the field that value than you can lock it otherwise you see nothing as it happens

on the on exit sheet action unlock the field ....

let me know

Anonymous
Not applicable

a locked field cannot be unlocked by doing selections

you need an Action (like unlock field, unlock and clear all) or manually unlock field

when you Change to sheet B do you see the locked field?

post sample so we can further help you

qlikmpate0
Creator II
Creator II
Author

How can I post a sample without confidential info. sorry never uploaded a qvw ?

qlikmpate0
Creator II
Creator II
Author

I have got no trigger like this onexit sheet only on activate sheet.

Anonymous
Not applicable

maybe this is the Problem:

you are doing something on sheet a e.g set variable (as you explained)

then you select the field using your variable

then you goto sheet b and do some selections

one of the selections Drops the selection of your field which you want to lock

you Change to sheet a (whenthe Trigger should fire), but there is not selection on your field and locking doesnot

work

try this:

goto sheet a, define your variable and set your field

now goto current selection box, select your field, right mouse click AND LOCK your field

then goto sheet, do whatever you need to do and goback to sheet a

NOW your field MUST still be locked!

qlikmpate0
Creator II
Creator II
Author

Thank you this worked locking the selections on sheet A  and then changing  to sheet B entering selections and then return back to sheet A, the display shows for the previous selection, but when you press clear the lock selection stay.

Thank you very much Rudolf Linder and   Alessandro Saccone
much appreciated.