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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator 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

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

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

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

View solution in original post

2 Replies
Not applicable

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

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

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

chriscools
Creator II
Creator II
Author

perfect, thanx!!!