topic Re: Year in edit script in QlikView

Year in edit script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Year in edit script

agigliotti — Wed, 11 Sep 2019 07:55:25 GMT

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

Re: Year in edit script

ljackson — Wed, 11 Sep 2019 10:34:16 GMT

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