Variables in script + user input box

[#1]

I would now like to use the variable (vDate3) and load it during the load script in a table (whilst still being able to update via input box), creating a formula similar to this:

Number - $(vDate3) as Number2;

Although am having issues - have attached a doc for "clarity?"

Kind regards, Rich

let vDate1 = 0;
Set vDate2 = 5;
Set vDate3= '=vDate1 + vDate2';  // << updates when user makes selection in input box

TempData:
Load *,
Number - '=(vDate3)' as Number2  // <<- how to update to have live value taken from interface/input box as per above
resident Data;
drop table Data;

[sunny_talwar]

Oh so just by changing the variable (and without reloading) you are expecting the number2 column to update? That is not going to happen. You def. need to refresh the application to make this to work

[#3]

ah ok

Thanks for your time (will use set analysis & variables - was hoping to move part to the script if possible)

[#4]

Hi Richard,

Please find the attached application,

The changes are getting reflected when you change the input box value.

-Uva

[#5]

Hi Richard,

Please find the attached application,

The changes are getting reflected when you change the input box value.

-Uva