Load query from Script: 2015 & 2016

[knightwriter]

Hi All,

I am looking to ammend my script to include 2016 data. Currently I am using the InYear expression and a specific car type (as below).

How do I change this to incorporate 2015, 2016 and my specific car type?

LOAD * FROM \\$(oEnvironment)\QlikView\Qvds\Cars.qvd (qvd)

where InYear([Car.Planned Sell Date], Today(), 0) AND

([Activity.Type]='Car Sales - General') ;

Many thanks.

[sunny_talwar · Accepted solution]

May be this:

LOAD *

FROM \\$(oEnvironment)\QlikView\Qvds\Cars.qvd (qvd)

Where (InYear([Car.Planned Sell Date], Today(), 0) or InYear([Car.Planned Sell Date], AddYears(Today(), 1), 0)) AND

([Activity.Type]='Car Sales - General');

[Anonymous]

Hi,

could this script work for you?:

LOAD * FROM \\$(oEnvironment)\QlikView\Qvds\Cars.qvd (qvd)

where (InYear([Car.Planned Sell Date], Today(), 0)

or

InYear([Car.Planned Sell Date], AddYears(Today(),1), 0))

AND

([Activity.Type]='Car Sales - General') ;

[tamilarasu]

@Hi knightRaider,

Another solution,

LOAD * FROM \\$(oEnvironment)\QlikView\Qvds\Cars.qvd (qvd)

where Year([Car.Planned Sell Date]) ='2015' And  Year([Car.Planned Sell Date])='2016' AND

([Activity.Type]='Car Sales - General') ;

Or

Where match(Year([Car.Planned Sell Date]),'2015','2016') And ([Activity.Type]='Car Sales - General');

[buzzy996]

try this,

match(InYear([Car.Planned Sell Date], Today(), 0),'2015','2016')