Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what about adding: where Year >= 2016 in your load statement?
what about adding: where Year >= 2016 in your load statement?
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';