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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?