topic Re: Load query from Script: 2015 & 2016 in QlikView

Load query from Script: 2015 & 2016

knightwriter — Wed, 18 Nov 2015 15:43:32 GMT

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 — Wed, 18 Nov 2015 15:45:46 GMT

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 — Wed, 18 Nov 2015 15:46:44 GMT

Hi,

could this script work for you?:

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

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

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

AND

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

tamilarasu — Wed, 18 Nov 2015 15:53:26 GMT

@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') ;

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

buzzy996 — Wed, 18 Nov 2015 15:57:46 GMT

try this,

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