Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
dan-ketil
Contributor II

Wrong day of year

Hi

Trying to figure out why I get the wrong day of year.

I have a text box where I put this: =DayNumberOfYear(Start)

Start is a date ield that contains the start date for a production batch. It would typically look like: 14.12.2011 12:00:00

I have tried it with the Now() and Today() function as well.

= 'dayYTD: ' & DayNumberOfYear(Now())

Given todaysdate: 20.12.2011 it should return 354, but it return 355.

Can any one please ket me in on why?

Dan

7 Replies
MVP
MVP

Re: Wrong day of year

DayNumber of year always uses years based on 366 days, so a specific day of month always gets the same number assigned.

Try:

=Today()- yearstart(Today()) +1

edit

Partner
Partner

Wrong day of year

Hi, Dan,

I get 355 with Now(), look at your systemdate.

Greetings from Munich

Martina

EVACO GmbH

dan-ketil
Contributor II

Wrong day of year

Martina: I also get 355, but it should show 354. At least according to my calendar.

Dan

dan-ketil
Contributor II

Wrong day of year

Swuehl: It get 354 with your code yes, but how to use it if I have a field with date.

Like my start date. I want to get the correct day of year for that given date.

Dan

MVP & Luminary
MVP & Luminary

Wrong day of year

Hi,

I think Qlikview is calculating 29 Days for February.  That is what Swuehl said, if you want exact days use the above expression suggested by Swuehl.

Regards,

Jagan.

Partner
Partner

Wrong day of year

Hi, Dan-Ketil,

you can use in the expression a datefield with the Num-function:

=Num(Datefield)-yearstart(Datefield) +1

Greetings from Munich

Martina

EVACO GmbH

MVP & Luminary
MVP & Luminary

Wrong day of year

Try using this

=DateFieldName- yearstart(DateFieldName) +1

Regards,

Jagan.