topic Re: USING LIST BOX VALUE IN SCRIPT in QlikView

USING LIST BOX VALUE IN SCRIPT

mosha231 — Wed, 30 Aug 2017 11:01:08 GMT

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 — Wed, 30 Aug 2017 16:53:26 GMT

Hi,

1 Example:

petter — Wed, 30 Aug 2017 22:31:43 GMT

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

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

mosha231 — Thu, 31 Aug 2017 07:36:51 GMT

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