topic Re: Reset Inputfield values in QlikView

Reset Inputfield values

patroser — Mon, 30 Mar 2015 14:46:54 GMT

Hi there!

I got stuck with a little problem concerning my input fields.

I use them for budgeting.

I use the following macro to clear the fields.

Sub ResetInputField

' Reset the InputField

set fld = ActiveDocument.Fields("InputFieldName")

fld.ResetInputFieldValues 0, 0 ' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value

End Sub

Unfortunately it doesn't work on access point.
So I also already tried to reset the field within my partial reload.
But after dropping the field and rejoining it within one partial reload, the application still keeps the values of the input fields.

Is there any clear way to reset the value of the input field within the script or at least without a macro (or a macro that works on AJAX)?

Thanks in advance!

Best regards
Patrick

Re: Reset Inputfield values

sunny_talwar — Mon, 30 Mar 2015 14:52:48 GMT

You can use a bookmark and a button action to reset inputfield values to something specific. For instance if you want all the values to be 0, then enter 0's for all of them and create a bookmark as follows (make sure to select include Input Field Values, and exclude Include Selections in Bookmark)

You can then use this bookmark to reset the inputfields to 0.

HTH

Best,

Sunny

Re: Reset Inputfield values

patroser — Tue, 31 Mar 2015 09:31:33 GMT

Works great, thanks!

Re: Reset Inputfield values

sunny_talwar — Tue, 31 Mar 2015 09:59:43 GMT

Great, I am glad I was able to help.

Best,

Sunny

Re: Reset Inputfield values

satishkurra — Wed, 10 Feb 2016 21:23:46 GMT

Hi Sunny

Thanks for this.

I'm looking for a similar kind of requirement.

The change is i want to reset back to the initial values.

I followed the same approach

1. Create a book mark with

a. Uncheck Selections in Bookmark

b. Check Include Input Field Values

Bookmark Name is BM01 for example

2. Now i'm creating a button with Action Type as Bookmark and Action as Apply Bookmark and provided the Bookmark ID as BM01

3. Now if i click the button it is not resetting to the initial value.

Am i missing something here.

Thanks in advance

Satish

Re: Reset Inputfield values

sunny_talwar — Wed, 10 Feb 2016 21:25:59 GMT

The steps you have taken seems right. Can you share a sample to check it out?

Re: Reset Inputfield values

satishkurra — Wed, 10 Feb 2016 21:38:50 GMT

Hi Sunny

Please find attached the sample qvw

Thanks

Satish

Re: Reset Inputfield values

sunny_talwar — Wed, 10 Feb 2016 21:46:06 GMT

I am guessing you are not doing this error in your actual application

Re: Reset Inputfield values

sunny_talwar — Wed, 10 Feb 2016 21:47:10 GMT

I created a new bookmark using the steps you just mentioned and it seems to be working well

Re: Reset Inputfield values

satishkurra — Wed, 10 Feb 2016 21:48:12 GMT

Hi Sunny

Even after changing, if i click Clean Input Field text object, the input field clear is not happening.

Thanks for pointing out:)

Thanks

Satish

Re: Reset Inputfield values

satishkurra — Wed, 10 Feb 2016 21:58:40 GMT

Thanks Sunny...

Re: Reset Inputfield values

satishkurra — Thu, 11 Feb 2016 18:53:57 GMT

Hi Sunny

I figured out that we can also achieve this without bookmark.

Approach: Right click on the chart and select "Restore All Values"

Thanks

Satish

Re: Reset Inputfield values

sunny_talwar — Thu, 11 Feb 2016 18:56:22 GMT

Super, thanks for sharing that. I am going to test that right away

Re: Reset Inputfield values

wwistam — Thu, 07 May 2020 21:47:48 GMT

Hi Patrick,

Just wondering if you can share how you used input field for budgeting, to what extend. Interesting concept.

Thanks,

Will