topic Clear Input Boxes in QlikView

Clear Input Boxes

Mon, 27 Apr 2009 20:41:52 GMT

I'm trying to clear all of the input box items in the attached *.qvw using VB script and the "Clear Input Values" button. For some reason my code is only clearing out the top two items. Anyone know what I'm missing to clear all of the items out?

thanks,

rob

Clear Input Boxes

disqr_rm — Mon, 27 Apr 2009 20:55:32 GMT

Hi Rob,

Try following:

sub input_clr
'Clear All input boxes
set ClearAllib = ActiveDocument.GetSheetObject("IB01")
for i = 1 to ClearAllib.GetNoOfRows
ClearAllib.SetVariableContent i-1,"",true
next
end sub

Thanks

Clear Input Boxes

Mon, 27 Apr 2009 20:59:03 GMT

Do you not just need it to be:













sub




 input_clr
'Clear All input boxes

set



 ClearAllib = ActiveDocument.GetSheetObject("IB01"
)
""

 ,
true
""

,true
""


,true
""


,true
""


,true

' ActiveDocument.ClearAll false
end

Regards,

Gordon

sub

Clear Input Boxes

Mon, 27 Apr 2009 21:00:30 GMT

That came out well! Should have read:

sub input_clr
'Clear All input boxes
set ClearAllib = ActiveDocument.GetSheetObject("IB01")
ClearAllib.SetVariableContent 0,"",true
ClearAllib.SetVariableContent 1,"",true
ClearAllib.SetVariableContent 2,"",true
ClearAllib.SetVariableContent 3,"",true
ClearAllib.SetVariableContent 4,"",true
' ActiveDocument.ClearAll false
end sub

Clear Input Boxes

Mon, 27 Apr 2009 21:02:50 GMT

Thanks Rakesh. That did the trick.

rob

Clear Input Boxes

Mon, 27 Apr 2009 21:04:26 GMT

Gordon,

That also worked. Thanks.

rob