Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Not applicable

Day number of year

Hello all,

How do I get the order number of today's day, when it is the 140th day of the year (20/5/2009)?

My purpose is to calculate an annualized number of a product's consumption, when I get the updated YTD consumption every day from ERP:

YTD consumption x 365 / <day number of today> = annualized consumption.

Cheers!

Teppo

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try this formulae =today()- YearStart(today()).

i think this should help you.

CheersYes

- Sridhar

View solution in original post

2 Replies
Not applicable
Author

Hi,

Try this formulae =today()- YearStart(today()).

i think this should help you.

CheersYes

- Sridhar

View solution in original post

Not applicable
Author

It works! Cool Thanks!