Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set field range in load script

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

Tags (2)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Set field range in load script

Don't load the data older than 2010

LOAD stuff

FROM somewhere

WHERE year >= 2010;


talk is cheap, supply exceeds demand
3 Replies
Gysbert_Wassenaar
Not applicable

Re: Set field range in load script

Don't load the data older than 2010

LOAD stuff

FROM somewhere

WHERE year >= 2010;


talk is cheap, supply exceeds demand
Not applicable

Re: Set field range in load script

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?

Not applicable

Re: Set field range in load script

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