Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rdsuperlike
Contributor

Fiscal year - 4years

I have a column in my load statment as below:

FISCAL_YEAR

how do i load the data to last 4 years here ?

there is no query.It loads from a system generated csv file. So i want to restrict on load sttamenet

Tags (1)
2 Replies

Re: Fiscal year - 4years

How does the FISCAL_YEAR field look like? Does it contain straight numbers?

ramoncova06
Valued Contributor III

Re: Fiscal year - 4years

you can also apply a where condition to a csv file

so if the fiscal year has a format of YYYY then you could do

load

*

from .....

where FISCAL_YEAR >= 2012