InputField Macro

[Anonymous]

Hey Community,

i use this macro

26. To reset InputField values

Sub ResetInputField

' Reset the InputField

  set fld = ActiveDocument.Fields("InputFieldName")

  fld.ResetInputFieldValues 0,  0   ' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value

End Sub

From Useful Qlikview Macros

My Question is how can i rest more then one field ?

And in one button to rest all my field to the last data from DB

Thank

[#2]

Hi

I have scenario for input filed,i need to enter the data for forecasting which is not aviable

for ex

                                            inputfiled

year  (Sales growth  rate)   (Sales Growthrate)

2013   53                                    -------------

2014     67                                  ---------

2015     56                                   ----------

2016           45                                ------------

2017            ?                                           ?

How? Please let me know

Thiru

[tamilarasu]

Hi,

Please start a new thread and elaborate your complete requirment (If possible, attach a sample document).

[#4]

Hi

I am not able to attach here,

Please click the below link for qvw file

INPUTFILED

Thanks

Thiru

[tamilarasu]

Got it. Please explain what is your issue. I would suggest you to create a new discussion for this.

[#6]

Hi

Thanks for your reply.

I want to show forecasting analysis here

actually we have data up to today(i.e 2016).

user want analyse forecasting data

1.Based on Sales annual growth rate the forecasting(doted lines need to reflect i.e growth rate 1,2 ,3 percentage etc,,)

2.If he enter any values in future years (from 2016 on wards) that also  need to be change in forecasting lines

  here

a.If i enter any value in input filed upto 2016 is working

b.If i try to enter  a value after 2016 it is not taking and displaying(this is the qs)

Please do the need ful

Thanks

Thiru