# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator

## Getting years as a number, not date

I have the following expression which works fine and converts to '2015'

but when I modified it to:

I want it to take 2015 x 12 = 507936 instead of 24180.

How do I get it to look at the year as a number for this expression instead of a date?

Zag

1 Solution

Accepted Solutions
MVP

You want it to return 12*2015 = 24180?

Then just calculate a year value, not a formatted date:

If you want it to return 507936, that's what your expression already does:

4 Replies
MVP

Maybe something like

MVP

You want it to return 12*2015 = 24180?

Then just calculate a year value, not a formatted date:

If you want it to return 507936, that's what your expression already does:

MVP

(Year(Today())-1)*12

Creator III

for 24180:

calculate a year value, not a formatted date: