topic using script editior in QlikView

using script editior

Thu, 14 Jul 2011 10:16:22 GMT

In my script editor I want to load data only in a specific date range ie from 01/01/2010 onwards

how do I write this?

Thanks

This is my script

LOAD IncidentID,

Region,

Site,

DateRaised,

Year(DateRaised) as Year,

Month(DateRaised) as Month,

ReportedBy,

NonConformanceArea,

NonConformanceAreaCategory,

Description,

Priority,

CloseOut,

CompletionDate

SunilChauhan — Thu, 14 Jul 2011 10:25:51 GMT

in script editor write your load like below

load

column1,

column2

.....

from path where DateRaised>='01/01/2010'

erichshiino — Thu, 14 Jul 2011 12:57:58 GMT

if you have some trouble with the comparison with the date as a string,

you can replace the condition in the previous post to:

from path where DateRaised>= makedate(2010)

from path where year( DateRaised) >=2010

Hope this helps,

Erich

Fri, 15 Jul 2011 13:04:28 GMT

Thanks

It works!