Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mosha231
Contributor II
Contributor II

USING LIST BOX VALUE IN SCRIPT

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


3 Replies
el_aprendiz111
Specialist
Specialist

Hi,

1 Example:

Date12.png

petter
Partner - Champion III
Partner - Champion III

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
Contributor II
Contributor II
Author

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