Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Clear Input Box with predefined values

I have tried a variety of things to get my input box to clear... I have set the variable to '' in a button action as well as in a Document Settings Trigger. I have also tried to call the macro below through a button. Nothing is working. Can anyone help me?

sub input_clr
'Clear All input boxes
set ClearAllib = ActiveDocument.GetSheetObject("IB01")
ClearAllib.SetVariableContent 0,"",true
end sub

 

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

I believe the problem is that you have rules for the value.

As blank is not a listed value, you just can't clear it.

If you add the blank option you can do it.

View solution in original post

5 Replies
Not applicable
Author

Bump

Not applicable
Author

In the button actions there is an option in External/Set Value.

If you dont assign a value it turns blank.

That doesnt work?

Not applicable
Author

No, blanking out the variable does not clear the input box. And I don't see an option to clear an object, only a field. I've attached a sample qvw. Thanks for looking inot it for me.

Not applicable
Author

I believe the problem is that you have rules for the value.

As blank is not a listed value, you just can't clear it.

If you add the blank option you can do it.

Not applicable
Author

This worked great! Although in my solution, I had to use
=concat(distinct TYPEA, ',') & ','  with no space after the final comma in order to change the input field to blank.
THANKS!