topic Inputfield issue in QlikView

Inputfield issue

Sat, 11 Jan 2014 16:40:24 GMT

Hi,

I had created one input field, after reload I can able to edit the values of field. But when I reload it is not replacing with data source values.

Thanks,

Yaseen

Re: Inputfield issue

jagannalla — Sat, 11 Jan 2014 16:42:59 GMT

Hi Yaseen,

I also faced same issue. Hope some one can help us on this.

Thanks,

Jagan

Re: Inputfield issue

sundarakumar — Sat, 11 Jan 2014 17:03:50 GMT

input field values lost after reload

Please refer to the above link.

Hope this helps.

-Sundar

Re: Inputfield issue

luciancotea — Sat, 11 Jan 2014 23:17:13 GMT

This is the default behavior. If you need to reset the INPUT FIELD to database values, use this macro:

sub ResetInputField

set fld = ActiveDocument.Fields("FieldName")

fld.ResetInputFieldValues 0

end sub

Re: Inputfield issue

Sun, 12 Jan 2014 06:11:08 GMT

You can use trigger and reset the varible on Reload..........

Selva

Re: Inputfield issue

stevedark — Sun, 12 Jan 2014 14:42:05 GMT

I have had mixed results with inputfields, one time it appeared that values that were captured against one row were assigned to a different row when the data was reloaded with slightly different records. There may have been a specific reason why it behaved odd in this case - but the upshot is that I don't trust them too much.

If any data capture is required I tend to push this out to Excel spreadsheets, or Google Spreadsheet.

Cheers,

Steve

Re: Inputfield issue

Mon, 31 Mar 2014 05:13:09 GMT

Hi,

Kindly try this solution.

Document properties - Triggers - OnPostReload - Add Run Macro - Edit Module - enter the script below with ur field.

sub resetvalues

set f = ActiveDocument.Fields("Fieldname")

f.ResetInputFieldValues 0, x

end sub

After that, reload your document and the macro will run automatically after reload.

Hope this would solve!

Thanks and best regards,

Chanel