How to clear input fields with a button

[#1]

Hi, I have a column of inputfields in a grid, and even after a reload, the values i modified are still present. I would like to create a button that will set all the values of that inputsum(field) to 0. Anyone have any insight on how this can be done?

[aveeeeeee7en]

Hi

You can do this with the help of Macro.

Check this out:

Re: InputSUM will change after reload?

Regards

Aviral Nag

[marcus_sommer · Accepted solution]

Maybe this is helpful:

sub ClearInputFields

dim fld1

set fld1 = ActiveDocument.Fields("YourInputField")

fld1.ResetInputFieldValues 0

end sub

Further possibilities you could find in APIGuide.qvw in your install-folder.

- Marcus

[giakoum]

http://community.qlikview.com/thread/45050

http://community.qlikview.com/docs/DOC-1852

[sathishkumar_go]

Hi,

use this macro

sub ResetField()
Set oField = ActiveDocument.Fields("FieldName")

oField.ResetInputFieldValues 0

-Sathish

[#6]

Many thanks guys! Works perfectly!

[vsabbise]

May I know how do I achieve this in qlik Sense ? Thanks