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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!