topic Re: Clear input with a button in QlikView

Clear input with a button

Anonymous — Tue, 13 Jan 2015 16:50:52 GMT

Hi guys,

I have a table with four editable fields and I would like to make them empty by pressing a button.

I have read and tried several examples on the forum but they didn't worked.

Surely I'm doing something wrong but I do not know what.

Can anyone help me? thanks a lot

Re: Clear input with a button

reshmakala — Tue, 13 Jan 2015 16:55:46 GMT

Hi.. please find attached. Is this what you are looking for?

Re: Clear input with a button

rubenmarin — Tue, 13 Jan 2015 16:57:05 GMT

Hi Mattia,

You're refering to "Input fields"? in this case you can write a macro:

Sub ResetInputFields

SET fld = ActiveDocument.Fields("YourInputFieldName")

fld.ResetInputFieldValues 0

End Sub

The button just needs to call this macro with an External -->Run Macro action.

Re: Clear input with a button

Anonymous — Tue, 13 Jan 2015 17:05:46 GMT

i get error... the columns where I enter my data to be deleted are called: premi nazionali S/N, premi listing S/N .

so I want to first try with a column and I did:

Sub ResetInputFields

SET fld = ActiveDocument.Fields("premi nazionali S/N")

fld.ResetInputFieldValues 0

End Sub

but dont work

Re: Clear input with a button

Anonymous — Tue, 13 Jan 2015 17:07:00 GMT

No, i have a table with fields where you can write

Re: Clear input with a button

Anonymous — Tue, 13 Jan 2015 19:06:30 GMT

Hi Mattia,

that macro resets an inputfield and restores original values, it can't make it empty.

However, in ActiveDocument.Fields instruction you have to insert input filed's name, not column's name (that i think it's an expression, such as InputSum or InputAvg).

Elena

Re: Clear input with a button

Anonymous — Tue, 13 Jan 2015 19:09:31 GMT

the names are the same because my column takes its name from the script where i have my inputfield

Re: Clear input with a button

jzimolong — Wed, 14 Jan 2015 01:56:24 GMT

Not sure, but the following thread has a sample at the very end that might help:

http://community.qlik.com/thread/32005

Re: Clear input with a button

engishfaque — Wed, 14 Jan 2015 04:47:45 GMT

Dear Mattia,

Kindly find attached QVW document,

Kind regards,

Ishfaque Ahmed

Re: Clear input with a button

krishna20 — Wed, 14 Jan 2015 05:56:47 GMT

Hi,

follow this link,it may helps.

http://community.qlik.com/message/185926#185926

Regards

Krishna

Re: Clear input with a button

rubenmarin — Wed, 14 Jan 2015 08:03:22 GMT

Hi Mattia I made a simple example whit input fields, check if you have something like this or you are using something different than input fields.

Re: Clear input with a button

Anonymous — Wed, 14 Jan 2015 08:25:24 GMT

is a graph, you have attached the wrong file?

Re: Clear input with a button

rubenmarin — Wed, 14 Jan 2015 08:31:14 GMT

Ops, right, it's the worng file, sorry. Attached again.

Re: Clear input with a button

Anonymous — Wed, 14 Jan 2015 08:42:08 GMT

Ruben now it works.

I did wrong because I didnt insert in the name of the macro the same namein the sub.