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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
nkosinde13
Creator
Creator

DayNumberOfYear function

Good day all

Can someone please explain why Qlikview uses 366 days for the DayNumberOfYear function and if there's any way of getting around this. E.g. if I'm looking for number of days when February ends on the 28th I still get 366, shouldn't I be getting 365?

Thanks and looking forwards to the responses.

Matlotlo

1 Reply
markp201
Creator III
Creator III

Totally agree.  I just ran into this design bug with our master calendar.

Now I have to use calendardate - yearstart(calendardate) + 1

As the Sicilian would say - INCONCEIVEABLE!!!