topic Re: Variables in script + user input box in QlikView

Re: Variables in script + user input box

Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: Variables in script + user input box

Gysbert_Wassenaar — Wed, 11 May 2016 16:51:23 GMT

Try this:

let vDate1 = 0;

Set vDate2 = 5;

Let vDate3= rangesum($(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;

Re: Variables in script + user input box

trdandamudi — Wed, 11 May 2016 16:51:35 GMT

Replace the below line:

Number - '=(vDate3)' as Number2 // <<- how to update to have live value taken from interface/input box as per above

With the below :

Number - $(vDate3) as Number2

Re: Variables in script + user input box

sunny_talwar — Wed, 11 May 2016 16:53:12 GMT

I have added a trigger instead of using the variable definition to set the value for vDate3. See if this helps.

Best,

Sunny

Re: Variables in script + user input box

Wed, 11 May 2016 17:17:10 GMT

Hi Sunny,

Thanks for review - unfortunately it the trigger doesn't appear to update following a new drop down selection..?

Gysbert / Thirumala

when scripted as follows, this hardcodes the result of vDate3 in the table (ignoring "future" input box selections)

Number - $(vDate3) as Number2

Any other suggestions?

Re: Variables in script + user input box

sunny_talwar — Wed, 11 May 2016 17:19:31 GMT

A new drop down selection? in vDate1?

Re: Variables in script + user input box

sunny_talwar — Wed, 11 May 2016 17:20:25 GMT

Seems to be working for me

Re: Variables in script + user input box

Wed, 11 May 2016 17:27:50 GMT

Hi Sunny,

Thanks for your patience - using your example, when reloading the doc - all is well...

When the value in the input box (vDate1) is adjusted, the "Number2" in table (in red) appears to remain as before / per the reload

Is this the case for you?

Re: Variables in script + user input box

sunny_talwar — Wed, 11 May 2016 17:29:16 GMT

No, I see the number changing at my end.

I made some changes in the script als0:

//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;

//rename table TempData to Data;

Re: Variables in script + user input box

Wed, 11 May 2016 17:48:49 GMT

Hi Sunny, I see "vDate3" updates on new selection - although "Number2" remains as is?

What can I change so I see what you see (ie ensured I saved doc to my pc etc..)?

Re: Variables in script + user input box

sunny_talwar — Wed, 11 May 2016 17:51:26 GMT

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

Re: Variables in script + user input box

Wed, 11 May 2016 17:54:23 GMT

ah ok

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

Re: Variables in script + user input box

Wed, 11 May 2016 23:10:53 GMT

Hi Richard,

Please find the attached application,

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

-Uva

Re: Variables in script + user input box

Thu, 12 May 2016 11:17:49 GMT

Hi Richard,

Please find the attached application,

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

-Uva