topic Re: How to clear input fields with a button in QlikView

How to clear input fields with a button

Wed, 13 Aug 2014 14:54:42 GMT

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?

Re: How to clear input fields with a button

aveeeeeee7en — Wed, 13 Aug 2014 15:01:30 GMT

You can do this with the help of Macro.

Check this out:

Re: InputSUM will change after reload?

Regards

Aviral Nag

Re: How to clear input fields with a button

marcus_sommer — Wed, 13 Aug 2014 15:02:07 GMT

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

Re: How to clear input fields with a button

giakoum — Wed, 13 Aug 2014 15:02:08 GMT

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

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

Re: How to clear input fields with a button

sathishkumar_go — Wed, 13 Aug 2014 15:13:59 GMT

Hi,

use this macro

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

oField.ResetInputFieldValues 0

-Sathish

Re: How to clear input fields with a button

Wed, 13 Aug 2014 15:26:22 GMT

Many thanks guys! Works perfectly!

Re: How to clear input fields with a button

vsabbise — Wed, 14 Nov 2018 19:51:51 GMT

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