Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-12-17 06:44 AM

How can i substract Year field from Current Year?

Hi All,

I have a field Year.

Year:

2005

2006

2007

How can i create another field by substracting each value of Year Field from the Current Year.

How i need is

2012-2005

2012-2006

2012-2007

in a seperate field.

Thanks in advance.

Regards

Kumar

343 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2012-12-17 06:52 AM
Author

use this:

Load Year, year(today())-Year as NewYearfield

View solution in original post

283 Views
0 Likes
1 Reply
Not applicable
‎2012-12-17 06:52 AM
Author

use this:

Load Year, year(today())-Year as NewYearfield

284 Views
0 Likes