topic Re: Assign value to a variable in load script using Inputbox and MsgBox in QlikView

Assign value to a variable in load script using Inputbox and MsgBox

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Is it possible to have message box and inputbox in a load script where I advise

user to assign value to a variable vPriceType i.e. "Would you please choose Price Type"
assign number i.e. "1" for Distri or "2" for Street so when I reload script

I don't need to type text but only one number and then using assigned value 1 or 2
to re-assign textual value Distri or Street to vPriceType variable which I then use
in where clause i.e. where PriceType = vPriceType

Thanks in advance.

Amko

Re: Assign value to a variable in load script using Inputbox and MsgBox

swuehl — Sat, 04 Mar 2017 23:46:23 GMT

Something like this in the script:

Let vPriceType = Input('Would you please choose Price Type','Caption');

edit:

or to assing the text based on input 1 or 2:

Let vPriceType = Pick(Input('Would you please choose Price Type','Caption'),'Distri','Street');

Re: Assign value to a variable in load script using Inputbox and MsgBox

Sun, 05 Mar 2017 13:29:12 GMT

Stefan ich bedanke mich recht herzlich!

Thank you very much for solving this issue so fast

I used the variable in where clause like this and it works fabulous.

Where [PRICE TYPE] = '$(vPriceType)'