topic Re: Clear Input Box with predefined values in QlikView

Clear Input Box with predefined values

Thu, 26 Jan 2012 20:36:51 GMT

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

Clear Input Box with predefined values

Mon, 30 Jan 2012 17:09:19 GMT

Bump

Clear Input Box with predefined values

Mon, 30 Jan 2012 17:18:06 GMT

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

If you dont assign a value it turns blank.

That doesnt work?

Re: Clear Input Box with predefined values

Mon, 30 Jan 2012 17:34:17 GMT

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.

Re: Clear Input Box with predefined values

Mon, 30 Jan 2012 17:44:43 GMT

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.

Re: Clear Input Box with predefined values

Mon, 30 Jan 2012 18:05:25 GMT

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!