topic InputField Macro in QlikView

InputField Macro

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

i use this macro

26. To reset InputField values

Sub ResetInputField

' Reset the InputField

set fld = ActiveDocument.Fields("InputFieldName")

fld.ResetInputFieldValues 0, 0 ' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value

End Sub

From Useful Qlikview Macros

My Question is how can i rest more then one field ?

And in one button to rest all my field to the last data from DB

Thank

Re: InputField Macro

Gysbert_Wassenaar — Sun, 15 May 2016 07:39:20 GMT

It may be easier to remove all the data using the Reduce Data -> Remove All Values option from the File menu and then reload the document like I mentioned in this post: Re: InputField‌.

If you insist on macro's then you need to loop through a list of field names and call the ResetInputField subroutine with each field name as a parameter. Perhaps something like this:

Sub ResetInputField(strFieldName)

set fld = ActiveDocument.Fields(strFieldName)

fld.ResetInputFieldValues 0, 0

End Sub

Sub ResetAllInputFields

set flds = ActiveDocument.GetFieldDescriptions

for i = 0 to flds.Count - 1

set fld = flds.Item(i)

if fld.IsInputField then ResetInputField(fld.Name)

End Sub

Re: InputField Macro

Anonymous — Sun, 15 May 2016 07:55:41 GMT

Thank you again for you help, my client didn't want the first solution you gave me, the request is on button that will rest all my input field

On your macro i can use only one field (in my pic i have mroe then one, mark in yellow )

Sub ResetInputField(strFieldName)

set fld = ActiveDocument.Fields(strFieldName)

fld.ResetInputFieldValues 0, 0

End Sub

set flds = ActiveDocument.GetFieldDescriptions

for i = 0 to flds.Count - 1

set fld = flds.Item(i)

if fld.IsInputField then ResetInputField(fld.Name)

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 08:04:16 GMT

Hi David,

You can use below macro to reset all the input fields in single click. Attached sample for your reference.

Sub ResetInputField
fldArray= Array("Budget","Status","Date")  // Your input field names
For i=0 to UBound(fldArray)   
  set fld = ActiveDocument.Fields(fldArray(i))
  fld.ResetInputFieldValues 0,  0   ' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value
 Next  
End Sub

Re: InputField Macro

Gysbert_Wassenaar — Sun, 15 May 2016 08:10:05 GMT

Then you're executing the wrong sub with your button.

Re: InputField Macro

Anonymous — Sun, 15 May 2016 08:37:47 GMT

its work but when i do reload it failed

Re: InputField Macro

Anonymous — Sun, 15 May 2016 08:43:22 GMT

I use only one sub

Re: InputField Macro

Anonymous — Sun, 15 May 2016 10:03:45 GMT

Sub ResetInputField(strFieldName)

set fld = ActiveDocument.Fields(strFieldName)

fld.ResetInputFieldValues 0, 0

End Sub

Sub ResetAllInputFields

set flds = ActiveDocument.GetFieldDescriptions

for i = 0 to flds.Count - 1

set fld = flds.Item(i)

if fld.IsInputField then ResetInputField(fld.Name)

End Sub

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 10:12:54 GMT

There is something wrong in your load script. The above macro is not related with the load script. You can check the log file to identify the issue.

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 10:14:23 GMT

Like attached.?

Re: InputField Macro

Anonymous — Sun, 15 May 2016 10:28:36 GMT

I dont know something is dont work for me i add my app.

When i press the button its ok works fine but when i do reload its give me error

Re: InputField Macro

Anonymous — Sun, 15 May 2016 10:30:32 GMT

Can you look at my app ?

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 10:37:43 GMT

Sorry. I am using personal edition. I can look into your app only by Tuesday. Did you check the log file.? If possible, can you post your log file.?

Re: InputField Macro

Anonymous — Sun, 15 May 2016 10:43:14 GMT

I did Just add the log file.

Thx

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 10:55:53 GMT

I could not find any error line in the log file. But I am sure that this is not macro issue. Please post your script.!!

Re: InputField Macro

Anonymous — Sun, 15 May 2016 10:56:36 GMT

I post it above take a look

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 11:01:22 GMT

I meant your load script not macro.

Re: InputField Macro

Anonymous — Sun, 15 May 2016 12:52:01 GMT

Can you tell me why the vb script wont work on Web view ?

Re: InputField Macro

tamilarasu — Sun, 15 May 2016 13:33:58 GMT

Some macros may work on the WebView. Please check the below links.

Input box not working in web view | Qlik Community

Why macro doesn't work in webview

Why few things are not working in WebView?‌

BTW, Did you find the solution for the above error message.?

Re: InputField Macro

Gysbert_Wassenaar — Sun, 15 May 2016 16:38:06 GMT

And it's the wrong one.