Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikView Lock Selection

Hi All,

I have a trigger set on my sheet which automatically selects a field when opening the sheet.

Trigger Action: Select in Field

Field: Source

Search String: Car

I want to be able to lock this field including the search string no matter what selections are made on this sheet.

Is this possible?

Thanks.

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Add a Lock Field action after the Select in Field action.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

I've tried this but it doesn't work.

How do I enter the field and the search string - ie: Source = 'Car'

jonathandienst
Partner - Champion III
Partner - Champion III

Which does not work 0 the select or the lock? the two actions work for me.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

The select in field works a treat but the lock doesn't work.

If I clear the selections the field and search string that I want to lock down disappears.

jonathandienst
Partner - Champion III
Partner - Champion III

Lock applies to the current selection in that field. That's why you make the selection for Source and then Lock Source.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

I have the trigger set to make the source selection when opening the sheet including the search string of "Car" then I want to lock it down.

Trigger Action: Select in Field

Field: Source

Search String: Car

Trigger Action: Lock Field

Field: Source

This doesn't work for me - what am I doing wrong?