Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inputfield not resetting on reload.

I am using the following code:-

Inputfield Fcst_StartDate;

Load

Monthstart(now()) as Fcst_StartDate

Autogenerate(1);

First time I Load the application, the date in the field Fcst_StartDate is 01/03/2010 as I would expect. I then manually enter a date in the field say 27/02/2009.

When the app reloads 27/02/2009 is retained in the Fcst_StartDate.

How do I reset the field to the Monthstart formula when the app reloads?

2 Replies
Not applicable
Author



Paste using an idea I found on the previous post on this subject I set the following macro to reset the input field using the onopen action in the doc settings.

Sub Reset_Inputfield

"Fcst_StartDate").ResetInputFieldValues 0

end sub



This works when I reopen the document.









Not applicable
Author

Sorry the correct code is

Sub reset

activedocument.fields("Fcst_StartDate").ResetInputFieldValues 0

End sub