topic Re: where expression with current year in QlikView

where expression with current year

Fri, 31 Oct 2014 14:51:15 GMT

Hi experts

I would like to load data but only data from the current year. this is my expression:

resident job where Jahr = 2014 group by prodnr;

How can I define the current year instead of hardcoding it?

Additionally, I would like to load data from last year but only until the current date last year.

How would I habe to script this?

Thank you very much for your help!

Jan

alexandros17 — Fri, 31 Oct 2014 14:53:10 GMT

Year(Today())

let me know

Fri, 31 Oct 2014 14:57:02 GMT

Hi Allesandro

Works, cool. Do you also have an expression for the second part of my question?

Thank you for your help!

Jan

Fri, 31 Oct 2014 14:59:39 GMT

Hi Jan,

You can use the year(today()) functions in order to find the current year.

Just use the where YourDateField>=makedate(year(today())-1,month(today()),day(today()))

regards

Fri, 31 Oct 2014 15:12:00 GMT

Thank you for your help!

Hm, that expression did not work for me...

Jan