Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

load current year

Hi Experts

I have the following expression:

resident job where Gesellschaft = 'DC' AND Jahr=2014 group by jobnr;

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

Thank you for your help!

Jan

Tags (1)
1 Solution

Accepted Solutions

Re: load current year

year(today()) will return the current year

where Gesellschaft = 'DC' AND Jahr=year(today())

group by jobnr;

3 Replies

Re: load current year

year(today()) will return the current year

where Gesellschaft = 'DC' AND Jahr=year(today())

group by jobnr;

Re: load current year

resident job where Gesellschaft = 'DC' AND Jahr=Year(today()) group by jobnr;


talk is cheap, supply exceeds demand
Not applicable

Re: load current year

merci

Community Browser