topic Re: Restoring Values of Inputfields in QlikView

Restoring Values of Inputfields

Thu, 10 Jul 2014 22:50:53 GMT

Hi,

I have a table I created with an input field column. I want to be able to restore all the input field values to their default value by pressing a button, but I can't find the correct macro code to use. I can manually do this by right clicking on one of the input field cells and then selecting Restore Values-->Restore All Values. FYI, the default numbers are based on values in another table, so I don't want to just set them all to 0....

Thanks,

Sarah

Re: Restoring Values of Inputfields

Gysbert_Wassenaar — Fri, 11 Jul 2014 11:04:30 GMT

See this discussion: how to reset input field values using macro

Re: Restoring Values of Inputfields

Fri, 11 Jul 2014 14:02:04 GMT

Thanks! This did exactly what I wanted

Re: Restoring Values of Inputfields

Fri, 11 Jul 2014 14:03:44 GMT

Thanks! This did exactly what I wanted

Re: Restoring Values of Inputfields

Fri, 11 Jul 2014 14:11:51 GMT

So this worked, but can you explain what the below part of the answer does?

dim x(1)

x(0) = 0 ' element to reset