topic Reset field of inputfield in QlikView

Reset field of inputfield

Wed, 01 Jun 2011 18:19:23 GMT

Hello,

I have several fields of type inputField and always and every time when they filled with do not regain the initial value of 0.

How do you open the document where the fields will inputField zero.

Reset field of inputfield

Wed, 01 Jun 2011 19:28:44 GMT

Hi I think you may use a macro, triggered on open document event or triggered by a button in the application. Your macro code, might look similar to the following:

set fld = ActiveDocument.Fields("Budget")

fld.SetInputFieldValue 0, "0"

Regards

Reset field of inputfield

Wed, 01 Jun 2011 20:12:33 GMT

Ivan,

a macro foi essa que coloquei

Sub setCampos()

set fld = ActiveDocument.Fields("Custo")

fld.SetInputFieldValue 0, "0"

end sub

Acionada atravez de um botão, mas não funcionou.

Reset field of inputfield

Wed, 01 Jun 2011 20:52:53 GMT

Hi Gleybson, I do not write in portuguesse but I am able to understand since I speak spanish, you are right it will only reset the first value of the inputfield, this one should reset all the values:

Sub setCampos

set fld = ActiveDocument.Fields("Custo")

fld.ResetInputFieldValues 0

end sub

Regards

Reset field of inputfield

Thu, 02 Jun 2011 03:08:03 GMT

Ivan, sorry, his name thought you were Brazilian.

well, this time it worked perfectly.

Thanks.