# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Contributor II

## how to get allways the current year in a formula?

Hello,

i created a few textobjects with formulas to give some keynumbers on the first page of a qlikviewdocument.

for example i show invoicing for today, yesterday, current week, last week, and so on.

now in the formula for this week  i first got all invoicing for the past years but with the current weeknumber.

so i added the year also.

But how do i need to adapt the formula so it allways takes the current year?

because i don't want to have to remember next year i need to change the year number in al these expressions... 🙂

this is the formula:

=num(sum ( {<  LegalEntity = {'Pomax Belgium'} ,InvoiceType={'Faktuur'}, Year = {'2013'}   ,

Week =  {'\$(=   Week( Today()))'} >}   InvoiceQty*InvoicePriceUnitNet),'#.###,##€')

can someone give me a clue?

thanx!

chris

1 Solution

Accepted Solutions
Not applicable

## Re: how to get allways the current year in a formula?

=num(sum({<LegalEntity = {'Pomax Belgium'},

InvoiceType={'Faktuur'}, Year = {'\$(= Year( Today()))'},

Week =  {'\$(=Week( Today()))'} >}   InvoiceQty*InvoicePriceUnitNet),'#.###,##€')

2 Replies
Not applicable

## Re: how to get allways the current year in a formula?

=num(sum({<LegalEntity = {'Pomax Belgium'},

InvoiceType={'Faktuur'}, Year = {'\$(= Year( Today()))'},

Week =  {'\$(=Week( Today()))'} >}   InvoiceQty*InvoicePriceUnitNet),'#.###,##€')

Contributor II

## Re: how to get allways the current year in a formula?

perfect, thanx!!!