topic Re: Set field range in load script in QlikView

Set field range in load script

Fri, 28 Nov 2014 18:30:05 GMT

Hi everyone,

I have a year field that goes from 2001-2025. Is there a way to limit the field to 2010 to 2025 in the load script?

Thanks

Gysbert_Wassenaar — Fri, 28 Nov 2014 18:42:59 GMT

Don't load the data older than 2010

LOAD stuff

FROM somewhere

WHERE year >= 2010;

Fri, 28 Nov 2014 18:59:27 GMT

Hi Gysbert,

The Year field is part of a larger table load, like:

LOAD

Platform Name

Year,

Amounts

From

XYZ.qvd;

Can I modify the Year field in there, or do I have to do it separately?

Fri, 28 Nov 2014 19:04:42 GMT

I believe I just answered my own question. As you said, place "Where..." statement after FROM line. Thanks!