Control script execution with user input?

[#1]

We have a very large database that is about to get substantially bigger. I have a QV report that loads all the data for all claims, which worked fine when we were just getting started, but now we're about to quadruple its size. So I want to find a way to let the user select a claim number up front, and just download the data for that claim. I know that I can have the user enter a claim number using as "Input" statement in the script, but most people have a hard time remembering the numbers.

What I'd like to do is just download the claim numbers from the database, present them as a list box to the user, and let him select a value from there, which I would then pass as a variable to the "WHERE" clause in my "SELECT". Using an "Input" statement forces the user to enter something in the inputbox directly; he can't just select from the Listbox.

I've looked at SLEEP and EXECUTE statments, but they don't seem to fit the bill. So what I'd like is something like this:

SQL SELECT Claimnumber

FROM claimsdb;

(pause while user selects item from listbox, use OnSelect function to set variable vClaimRef)

(resume execution)

SQL SELECT *

FROM claimsdb

WHERE Claimnumber = vClaimRef

Is there a way to accomplish this?

[fosuzuki]

Check the attached files.

I used a xlsx file as my database table. Hope you can figure out how to convert it to SQL select...

Important: this will only work in QlikView Desktop. The Reload action will not be triggered when using browser to view the QVW. If you need to do it for users accessing the QVWs via browser, you'll have to use EDX. It is a lot more complicated...

Hope this helps