topic Not value or previous values in QlikView

Not value or previous values

Tue, 15 Mar 2011 12:57:46 GMT

Hi,

I am working on appending my qvds.

I created a variable to select the latest ID in the qvd.

I want to use that ID in the where clause of my database load script to not select that ID or the ID's before it. Just the ones afterwards.

So like this:

Load
*
from database
where id is not equal to variable or before this variable.

Is this possible?

any help is much appreciated,
thanks in advance

Not value or previous values

Miguel_Angel_Baeyens — Tue, 15 Mar 2011 13:16:52 GMT

Hello,

That should work with a piece of script similar to

SET vLoadFrom = 2000; Table:LOAD *;SQL SELECT *FROM TableWHERE id <= $(vLoadFrom);

Should the driver doesn't pass the value of the variable, you can always do that in the LOAD part of the script.

Hope that helps