Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try using the match function or wildcard *
Hi Scott Hay,
You can use the where clause with subfield function.
WHERE subfield(fiscalyear,'-',1) >= 2010
Regards