topic Re: Limited import for development mode in QlikView

Limited import for development mode

fabricius — Wed, 23 Jul 2014 09:09:50 GMT

How do I limit the amount of entries to be imported as I am working in "development mode" and do not want to wait for minutes every time a refresh is done?

Re: Limited import for development mode

alexandros17 — Wed, 23 Jul 2014 09:12:02 GMT

If you have a date set that date to an interval, for example:

select

...

from

...

where date >= 01/01/2014 and date <= 31/01/2014;

The same if you have a id field, the logic is set interval on significative fields.

Let me know

Re: Limited import for development mode

Anonymous — Wed, 23 Jul 2014 09:12:47 GMT

When in the script editor

Click <Debug>
Tick Limited Load
Enter number of rows
Click <Run>

Re: Limited import for development mode

struniger — Wed, 23 Jul 2014 09:12:54 GMT

Hi Soren,

Lookup the FIRST statement:

First 10 LOAD * FROM abc.csv;

Best regards

Stefan

Re: Limited import for development mode

MarcoWedel — Wed, 23 Jul 2014 09:13:02 GMT

In the script debugger you can select the number of rows to be imported.

regards

Marco