Prevent field from being cleared on sheet

[ivandrago]

Hi,

I have on one of my sheets a Sheet Event Trigger which will always show on the selection box Status = 'CLOSED', is it possible when a user clears the sheet it will prevent this field from being cleared? At the moment it will clear the field but when I go to another sheet and return back to that sheet the Status = 'CLOSED' will show; I want it to somehow not clear this field from the selection box altogether?

Thanks

Ivan

[#2]

Option 1 : You can make the field "always One selected value" .

Option 2: Use a clear Button which will -

ACTION : 'Clear Other Fields' Field: Status

See if it works

[ivandrago]

HI,

Could you show a example of option 1, yeah I thought about option 2 but they also could click the clear button that is defaulted by QlikView which would clear it.

Thanks

[#4 · Accepted solution]

Option 1:

Select at least one value and then Right click - Go to properties -----> General Tab ------------> Enable - "Always one selected Value"

[johnw]

Maybe lock the field when entering the sheet, and unlock the field when exiting the sheet?

[#6]

Hi,

I want to revive this thread by further detailing the same question. I use QV 11 functionality of selecting dimensions of a chart (straight table) by checking a listbox with these dimensions (that is loaded as an unlinked table in the data model).

The user will select the dimensions she/he wants to see, then select in other fields. Upon pressing the QV Clear button all selections get cleared included the selected dimensions. Is there a way to set the Dimension listbox field not to be cleared by the in-built Clear button?

The list box field name is hidden and there are many fileds that are typically selected at any time so I doubt that lock selections will be a convenient solution.

Do you know any solution to this?

Thanks.

[#7]

ok I found a possible way - I lock the selections in the listbox and select Overwrite Locked Field, then new selections of dimensions can still be made, and the Clear button doesn't clear them.