topic Using user prompt to load sql data in QlikView

Using user prompt to load sql data

Sun, 02 Jan 2011 13:06:25 GMT

Hello,

I'd like to generate a document that will prompt the user (who uses the doc via the Acess Point) to insert a value.

The document shall then use this input as part of the sql statement in the script.

Example:

SELECT * FROM EMPLOYEES

WHERE EMPLOYEE_ID=$(vEMP_ID);

Can anyone help me with this issue?

Using user prompt to load sql data

pover — Sun, 02 Jan 2011 18:46:57 GMT

Looking at this problem at another angle, why don't you load all the employee data in your model and then reduce the data automatically through section access according to the user's username in the AccessPoint?

Regards.

Using user prompt to load sql data

Mon, 03 Jan 2011 07:18:01 GMT

Unfortunately, it's not possible at this case as billions of records are stored in the DB and I can't load them all into the model.

Using user prompt to load sql data

pover — Tue, 04 Jan 2011 23:04:02 GMT

If the user uses QV Developer and could run the script, there would be no problem since you could use the input() function to receive a value for employee ID, but since the user is using accesspoint, there is no way to reload the document manually or as the user opens the document.

QlikView is not meant to do real-time queries, but rather; it is meant to consolidate data in RAM. If data volume is a problem then you will need to find a creative way of dividing the data up by QV files and linking those separate files with the help of actions, but that depends on your data and the type of reports you are creating.

Regards.