Year in edit script

[smilingjohn]

Hi All

I have a data which start from 2014 .
in my qlikview script i wanted to consider the data from 2016 and above .
how will i achieve this in the edit script ?
can please someone help on this .I am attaching my application 

Thanks in advance

[agigliotti · Accepted solution]

what about adding: where Year >= 2016 in your load statement?

[ljackson]

As the above reply says ....amend your script to this:

Test_Year:

LOAD Year,
Earnings,
Severity
FROM
Test_year.xlsx
(ooxml, embedded labels, table is Sheet2)

where "Year" >= '2016';