topic Clear input field value via macro in QlikView

Clear input field value via macro

Tue, 19 Jul 2011 12:47:30 GMT

Hi everyone,

i'm working on a QV where i have a simple table with an inputfield column.

I was wondering if smbdy would knew a VB or Java command to clear inputfield value, or force it to 0 for the active selection??

thanks for help

Clear input field value via macro

Tue, 19 Jul 2011 12:54:51 GMT

Here is a sample code.

set fld = ActiveDocument.Fields("Budgetentry")

fld.ResetInputFieldValues 0

Hope that helps.

Philippe

Clear input field value via macro

Tue, 19 Jul 2011 12:57:11 GMT

Hi thanks for the quik replys, however, i tried that but this one enable to restore the value of the input field, not to clear it or force it to 0.

Clear input field value via macro

Tue, 19 Jul 2011 13:04:16 GMT

I am using that macro to reset a straight table with inputsum cells in it . And it resets it to 0.

Philippe

Re: Clear input field value via macro

Tue, 19 Jul 2011 13:08:25 GMT

Try it with this file:

Input.zip

There is a sample like Phillipe mentioned.

Kind regards,

Björn

Clear input field value via macro

Tue, 19 Jul 2011 13:40:47 GMT

Well, i see now why this command doesn't work for me!!

Actually, my inputfield takes his values from an Xls file (to avoid losses of values, due to the inputfield issue: when adding some lines, the input field keeps it position and does not work as it should! i guess you understand what i m talking about.), and when i execute the macro, it takes the last known value since last reload and does not force it to zero as it work in your example when their is no source for this inputfield.

So because of that, i can't find any good command to force my input field value to be 0. any ideas?

Clear input field value via macro

Tue, 06 Mar 2012 04:52:06 GMT

Hi,

Could u plz tell me how to reset the input fields on pressing Clear on the toolbar

Thanks

Re: Clear input field value via macro

Anonymous — Tue, 06 Mar 2012 05:06:30 GMT

hi TheSariP

Hope the following macro attached qv file will be helpful for your problem

Regards

Ashok

Re: Clear input field value via macro

Anonymous — Tue, 06 Mar 2012 05:08:41 GMT

Hi qlik_techie,

Hope the above attached file will be give some idea to reset your input field using macro

Regards

Ashok