topic input field back to zero in QlikView

input field back to zero

Wed, 13 Mar 2013 12:30:59 GMT

Hi everybody,

Who knows exactly what makes input fields reinitialised to zero?

Is there any doc (except ref manual i read) about it?

Best regards

chris

Re: input field back to zero

Gysbert_Wassenaar — Wed, 13 Mar 2013 12:37:59 GMT

They'll be reset to their original value when you reload the document.

Re: input field back to zero

Wed, 13 Mar 2013 12:42:27 GMT

Hi Gysbert,

Not really. Sometimes it does when i modify the document and reload, sometilmes it doesn't when i just reload it.

Sometimes it does when i just reload it from an other place and replace it to the folder for access point.

Input fields are attached to records and document by the way

So i need to be sure what are exactly the events which set input fields to zero.

regards

chris

Re: input field back to zero

narender123 — Wed, 13 Mar 2013 13:30:26 GMT

Hi,

For this you have to create a button and set that button property to your input id to 0 so that when you will press that button then input box will reset to the value 0

Regards:

Narender

Re: input field back to zero

Gysbert_Wassenaar — Wed, 13 Mar 2013 13:30:48 GMT

Ah, looks like I'm totally wrong regarding inputfields. See here. That post is from 2009 however, so maybe this behaviour has changed in some way.

Re: input field back to zero

Wed, 13 Mar 2013 14:20:00 GMT

Thank you, but my goal is not to set values to zero but to understand how and when they are automatically reinitialised.

regards

chris

Re: input field back to zero

pennetzdorfer — Thu, 05 Sep 2013 13:27:27 GMT

Hi Chris, could you find out anything regarding that issue?

Thanks,

Florian

Re: input field back to zero

Tue, 17 Sep 2013 09:52:40 GMT

Hi Florian;

not a really full and definitive one!

Input Fields are stored into QVW and belongs to the user who created it. I mean, with QVS, each user can see his own values.

I guess, a new (modified) loaded QVW posted on the repository set every value to 0. But not every time (!?)

So if once you get more informations please let me know

Best regards

Christian

Re: input field back to zero

Mon, 31 Mar 2014 05:11:25 GMT

Hi,

I have a solution and you might try it out.

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