USING LIST BOX VALUE IN SCRIPT

[mosha231]

Hi everyone

i was trying to implement some SQL query in QV Script and got stucked

SQL QUERY:-

(VALID_TO > to_date(#prompt('PCD_From')#, 'yyyy-mm-dd')

#prompt('PCD_From')# - is taking value manually. Its like same as taking value from List box(User selection).

so is it possible to use dynamic values(based on user selection) in QV scripting and reflect the data without reloading the Qvw file ?

solution for this issue much appreciated.

Thanks in advance

[el_aprendiz111]

Hi,

1 Example:

[petter]

There is a function called Input() that can be used while running the load script:

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/SystemFunctions/system-...

It is not a list box but a simple prompt where you can input any type of text or number.

[mosha231]

Hi Fer,

Thanks for your quick response.

My main concern is do i have to reload the script every time whenever input given ?

Because i don't want to reload script. it should filter data on input/selection without script reload .

thanks & Regards