Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkcchowdary
Contributor

how to reload 5 years data instead of 10 years data

Hi I have 10 years of data in my table but in reload time I want reload only 5 years data

2 Replies
MVP
MVP

Re: how to reload 5 years data instead of 10 years data

You can use a where statement like this

LOAD *

FROM xyz

Where Year >= Year(Today()) - 4;

Re: how to reload 5 years data instead of 10 years data

If your data are in Date format:

LOAD

    "Date"

FROM [lib://conn/Book1.xlsx]

(ooxml, embedded labels, table is Sheet2)

where Year(Date)>Year(today())-4

Community Browser