topic Re: Reseting Input box to Default Value in QlikView

Reseting Input box to Default Value

montubhardwaj — Wed, 13 Jun 2012 20:36:23 GMT

Hi All,

I have created an Input box using these two variables: Sales (Min) and Sales (Max). It is working fine as expected. But when we clear out
the selections or Variable values, in the Input Box, still the previously entered values is shown( though it is not actually selected). How can I reset
back to say “Enter Values”. Below is the macro I am using. Thanks for your suggestions and time.

Sub input_box

A= Activedocument.variables("Sales (Min)").GetContent.string

B= Activedocument.variables("Sales (Max)").GetContent.string

Activedocument.Fields("Total_Sales").Select">" &A & "<"&B

End Sub

Re: Reseting Input box to Default Value

montubhardwaj — Thu, 14 Jun 2012 04:12:38 GMT

I mean when someone clears the selections, the Input box should also set to Default Values like "Enter Sales" etc. Now, even after clearing, it retains its previously entered value.

Re: Reseting Input box to Default Value

sivarajs — Thu, 14 Jun 2012 07:18:33 GMT

check the sample it might helps you

Re: Reseting Input box to Default Value

montubhardwaj — Thu, 14 Jun 2012 17:50:22 GMT

Hi Sivaraj. Thanks for looking into this. I actually want to clear the variables which are used the input boxes. So as soon as someone clears the overall selections, these variables should also re-set to default vales say "Enter vales" etc.I do not want to provide extra button for clearing these variables.

Re: Reseting Input box to Default Value

sivarajs — Fri, 15 Jun 2012 06:27:06 GMT

try using this

Sub input_box

A= Activedocument.variables("Sales (Min)").GetContent.string

B= Activedocument.variables("Sales (Max)").GetContent.string

Activedocument.Fields("Total_Sales").Select">" &A & "<"&B

A.Clear

B.Clear

End Sub

am not sure this will work but to avoid button you need to add something in macro

Re: Reseting Input box to Default Value

montubhardwaj — Fri, 15 Jun 2012 14:58:21 GMT

This code will clear variables values everytime but I want it to be cleared only when Clear all is pressed.