topic Re: Need help in Clear input box in QlikView

Need help in Clear input box

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I‘m using input box to input the value to change the records in the straight table and everything is working fine as required and I’m using button in order to clear the input box and is working fine as well. But the problem is when ever I click on button to clear the input box value the value in my straight table is changing as N/A. Instead of N/A I would like to see the original value.

Below example illustrates what I’m getting and what I’m expecting to see after clicking on clear button.

Example: Below is the Result which I‘m getting after clicking on clear button. Input value is ‘10’

Desc	Original Value	Result before clicking clear button (Original Value + Input Value)	Result after clicking clear button
A	10	20	N/A
B	20	30	N/A
C	30	40	N/A

‌

Below is the result which I would like to see after clicking clear button to clear input values

Desc	Original Value	result before clicking clear	Result after clicking clear button
A	10	20	10
B	20	30	20
C	30	40	30

As you can see after clicking on the clear button it has to go back to it‘s Original value.

Re: Need help in Clear input box

pradosh_thakur — Wed, 18 Oct 2017 09:19:19 GMT

Trh this

replace x with your variable

SUM(VALUE)+IF(ISNULL($(X))=-1,0,$(X))

Re: Need help in Clear input box

vikasshana — Wed, 18 Oct 2017 09:34:45 GMT

Pradosh,

Do you want me to put the above expression into the clear button? Here value is nothing but 'Original Value'?

Re: Need help in Clear input box

pradosh_thakur — Wed, 18 Oct 2017 09:47:49 GMT

no. i have changed the expression a litle

attaching sample qvw. please set the button as per your requirement to clear the input box value.

Re: Need help in Clear input box

vikasshana — Wed, 18 Oct 2017 10:13:20 GMT

Thanks for that Pradosh it's working fine and I've changed the button config, now I want only 'A' and 'B' to change to it's original value after clicking button. How to do that?

Re: Need help in Clear input box

pradosh_thakur — Wed, 18 Oct 2017 10:15:47 GMT

what about C? Your requirement is not clear to me now. tell me the output.

Re: Need help in Clear input box

vikasshana — Wed, 18 Oct 2017 10:21:00 GMT

The output will be something like this.

Input Value '10', after clicking on the button the 'C' value has to be 40 (Original Value + Input Value) but the 'A' and 'B' needs to change to it's Original Values (10 and 20)

Desc	Original Value	result before clicking clear	Result after clicking clear button
A	10	20	10
B	20	30	20
C	30	40	40

Re: Need help in Clear input box

pradosh_thakur — Thu, 19 Oct 2017 13:54:41 GMT

hi stalwar1‌

a little help here.

regards

Pradosh

Re: Need help in Clear input box

sunny_talwar — Thu, 19 Oct 2017 14:10:17 GMT

Check attached may be

Re: Need help in Clear input box

pradosh_thakur — Thu, 19 Oct 2017 14:16:14 GMT

awesome!! You do have cheat codes for every problem .

Re: Need help in Clear input box

sunny_talwar — Thu, 19 Oct 2017 14:30:44 GMT

Hahahaha I am sure this still might be the solution the OP is after because this seems rather not so convenient solution