Discussion board where members can get started with QlikView.
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?
View solution in original post
As the above reply says ....amend your script to this:
LOAD Year,Earnings,SeverityFROMTest_year.xlsx(ooxml, embedded labels, table is Sheet2)
where "Year" >= '2016';