Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

chriscools
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),'#.###,##€')

chriscools
Contributor II

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

perfect, thanx!!!