topic Re: Reset input Box values using Macro in QlikView

Reset input Box values using Macro

anuradhaa — Wed, 02 Jul 2014 04:20:17 GMT

Hi,

I'm new to macro and i'm using input box for get values for variable.

i want to reset input value.

please help me to do that.

Wed, 02 Jul 2014 04:23:34 GMT

can't you use a sheet level trigger instead of a macro?

anuradhaa — Wed, 02 Jul 2014 04:25:44 GMT

i don't know how to do that, could you please explain it

tresB — Wed, 02 Jul 2014 04:35:14 GMT

Using button trigger. See attached qvw.

sasikanth — Wed, 02 Jul 2014 05:23:26 GMT

Hi anu ,

Try some thing like below

sub clear

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list

list=Array("abc","45","xyz","")

prop.PreDefinedList = list

v.SetProperties prop

set ClearAllib = ActiveDocument.GetSheetObject("IB10")

ClearAllib.SetVariableContent 0,"",true

Erase list

list=Array("abc","45","xyz")

prop.PreDefinedList = list

v.SetProperties prop

end sub

anuradhaa — Wed, 02 Jul 2014 05:51:28 GMT

if this pop up macro edit window.

i have a feild called sales and need to clear that feild,

Sub Clear

ActiveDocument.Fields("FieldName").Clear

End Sub

but this doesn't work. please help me