Load Script with where condition -> No record loaded

[qlikviewaf]

Hi,

i created a QVD file (2 GB size) and i created the load script as follow; when i add at the end the "Where (SDDRQJ>=117000)" the script doesn't load the data.

After several mins on F42119 i got still 0 record. Seems like a performance issue. If i leave the where condition, then in few mins i got several millions of rows loaded.

I'm doing something wrong?

Thank you

[swuehl]

Remove the WHERE clause and reload.

a) How long does it take to load the table F42119? How many records have been loaded?

b) Create a list box for field SDDRQJ and filter values >= 117000

Please post a screen shot of the list box.

Also create a text box

=Count( If( SDDRQJ>=117000, SDDRQJ))

What is the result?

c) Add the where clause and reload the script.

How long does it take to load the table F42119? How many records have been loaded?