topic Script to reduce qvd load by certain values in a field in QlikView

Script to reduce qvd load by certain values in a field

Tue, 13 Nov 2012 16:01:40 GMT

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

Re: Script to reduce qvd load by certain values in a field

Tue, 13 Nov 2012 16:08:11 GMT

try using the match function or wildcard *

Re: Script to reduce qvd load by certain values in a field

jeffmartins — Tue, 13 Nov 2012 16:16:26 GMT

Hi Scott Hay,

You can use the where clause with subfield function.

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

Regards