Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cwitman1
New Contributor III

Where statement in load

I wanted to add a where statement that loads data that have the timestamp within the last 60 days.

What would this look like?

Tags (2)
2 Replies
beck110979
Valued Contributor III

Re: Where statement in load

Hi Chris,

check this: everyday sum of past 5 days

i hope that helps

Beck

passionate
Valued Contributor

Re: Where statement in load

Hi Chris,

Do you mean you want to load last 60 Days Data.

In that case use

LET vPeriod=  Today()-60


Load .....

From Source

Where Timestampfield = $(vPeriod);

Make sure timestamp format of both is same.

Regards,

Pankaj