Script to reduce qvd load by certain values in a field

[#1]

Can someone assist me in the syntax required for selecting multiple values from a field within a qvd.

I know I can use the 'or' sytax, but is there a more efficitent way of scripting the following:

UTILISATION:

LOAD

*

FROM

E:\QlikView\Applications\Production\datasources\elite\qvd\globalcalendar.qvd  (qvd)

where fiscalyear = '2010-11'

or    fiscalyear = '2011-12'

or    fiscalyear = '2012-13';

So basically i only want to load three years worth of data, but had I wanted to laod 10 years worth I would have to type out the or statement 10 times. Is there a better way of doing this?

Thanks in advance

Scott

[#2]

try using the match function or wildcard *

[jeffmartins]

Hi Scott Hay,

You can use the where clause with subfield function.

WHERE subfield(fiscalyear,'-',1) >= 2010

Regards