topic Why input field data is not updating in QlikView

Why input field data is not updating

Thu, 15 Dec 2011 14:45:56 GMT

Hello,

I'm using keyword INPUTFIELD for two fields while loading my application. After loading my application it is able to show input functionaliy in my application. Now i updated qvd file and reload the application. But the fields which we made inputfield is holding the previous loaded data only. It is not changing in the application with updated qvd file. The below code which i'm using.

I'm working on qlikview 10 SR3 version.

INPUTFIELD MinTakeOver,MaxTakeOver;

TakeOver:

LOAD TakeOver,MinTakeOver, MaxTakeOver, MinTakeOver as MinTakeOver1, MaxTakeOver as MaxTakeOver1;

LOAD 'BCButtterflyTimeA' as TakeOver,

max(BCButtterflyTimeA) as MaxTakeOver,

min(BCButtterflyTimeA) as MinTakeOver

From

T.qvd

(qvd);

Why input field data is not updating

swuehl — Thu, 15 Dec 2011 15:02:51 GMT

jacq

I believe Inputfields will "survive" reloads by design.

Please have a look e.g. into that:

http://community.qlik.com/message/31343

You could also write a macro that updates your inputfield with loaded data.

Regards,

Stefan

Why input field data is not updating

Thu, 15 Dec 2011 15:23:39 GMT

Swuehl

I gone through the link i understood the problem. But i'm not able reset input fields can clear me how to rest the input fields

Why input field data is not updating

johngouws — Tue, 24 Jan 2012 04:15:40 GMT

Hi Jacq.

I have the need to reset 2 INPUTFIELD, and found this discussion.

Thanks to all contributors. I modified the above example to suite my needs and it works perfectly.

Note: When defining the macro, remember to call it 'resetinput'.

sub resetinput

dim x(1)

x(0) = 0 ' element to reset

set fld = ActiveDocument.Fields("MaxTakeOver")

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

set fld = ActiveDocument.Fields("MinTakeOver")

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

end sub

Regards,

John