topic Re: Reset an inputfield by script (with button) in QlikView

Reset an inputfield by script (with button)

leenlart — Sat, 16 Nov 2024 21:52:54 GMT

Hello,

We have a little QV app that calculates values for the cost management team but allows them to modify the value.

I have a table with [calculated_value] and [costers_value] that is loaded with [costers_value] as an inputfield.

When the app is loaded, the [costers_value] is set to = [calculated_value].

The cost management team would like to have a button to reset the [costers_value] to the [calculated_value] for example if they begin modifications and leave and don't know where they left off.

It seems to me that I can create a button that will re-load the app, but doesn't the inputfield store the modified value, for how long, and how do I delete those values stored in memory ? Maybe this should be part of my reload script ?

Any ideas are welcome!

Re: Reset an inputfield by script (with button)

dplr-rn — Thu, 15 Nov 2018 16:17:04 GMT

Why dont you on reload set [calculated_value] to 2 variable costers_value and coster_value_default.

then use an on document open document trigger to set costers_value to coster_value_default.

Hope i understood the issue correctly

Re: Reset an inputfield by script (with button)

cwolf — Thu, 15 Nov 2018 17:15:26 GMT

Right click on a listbox with the inputfield:

Re: Reset an inputfield by script (with button)

cwolf — Thu, 15 Nov 2018 17:23:32 GMT

But you can also use a button that calls a macro:

sub ResetInputField
ActiveDocument.Fields("costers_value").ResetInputFieldValues 0
end sub

Re: Reset an inputfield by script (with button)

Gysbert_Wassenaar — Thu, 15 Nov 2018 17:24:50 GMT

One way is to use a bookmark: https://community.qlik.com/t5/QlikView-App-Development/Reset-Inputfield-values/td-p/820866

Another way is a double reload. See my post in this discussion: https://community.qlik.com/t5/New-to-QlikView/InputField/td-p/1110139

Re: Reset an inputfield by script (with button)

leenlart — Fri, 16 Nov 2018 08:35:48 GMT

Thanks, super interesting method.