Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

smilingjohn
Contributor III

Year in edit script

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Year in edit script

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

2 Replies
Partner
Partner

Re: Year in edit script

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

ljackson
Contributor

Re: Year in edit script

 

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