Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=num(sum({<LegalEntity = {'Pomax Belgium'},
InvoiceType={'Faktuur'}, Year = {'$(= Year( Today()))'},
Week = {'$(=Week( Today()))'} >} InvoiceQty*InvoicePriceUnitNet),'#.###,##€')
=num(sum({<LegalEntity = {'Pomax Belgium'},
InvoiceType={'Faktuur'}, Year = {'$(= Year( Today()))'},
Week = {'$(=Week( Today()))'} >} InvoiceQty*InvoicePriceUnitNet),'#.###,##€')
perfect, thanx!!!