topic Re: How to set up current year while loading data in QlikView

How to set up current year while loading data

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I try to limit my year peroid while loading data. The period I am looking for is from 1990 until current date (let's say 06/07/2016.

I did " WHERE Year (Date) > '1990' "

How can I do set up the second condition and set up the date is equal and less than the current date?

" WHERE Year (Date) > '1990' and Date < = ?? "

Thank you,

Becky

Tue, 07 Jun 2016 15:15:58 GMT

I cannot do this:

WHERE Year ( [Date]) > '1990' AND Year ( [Date]) < = Year (Now())

Tue, 07 Jun 2016 15:17:36 GMT

I am all set!

I can do the one shows above.

sunny_talwar — Tue, 07 Jun 2016 15:19:08 GMT

You got it to work now?

settu_periasamy — Tue, 07 Jun 2016 15:25:55 GMT

i think, this will also work..

WHERE Year ( [Date]) > '1990' AND [Date] < = Today();

Tue, 07 Jun 2016 16:49:49 GMT

Yes, thank you!

Tue, 07 Jun 2016 16:52:20 GMT

Yes, this works too.