Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here is a sample code.
set fld = ActiveDocument.Fields("Budgetentry")
fld.ResetInputFieldValues 0
Hope that helps.
Philippe
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.
I am using that macro to reset a straight table with inputsum cells in it . And it resets it to 0.
Philippe
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?
Hi,
Could u plz tell me how to reset the input fields on pressing Clear on the toolbar
Thanks
hi TheSariP
Hope the following macro attached qv file will be helpful for your problem
Regards
Ashok
Hi qlik_techie,
Hope the above attached file will be give some idea to reset your input field using macro
Regards
Ashok