Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Day number of Year wrong?

Daynumber.PNG

 

I have a simple chart that has production date as a dimension and Daynumberofyear(max(production date)) and above is what i am getting.

Why are all the sites saying we 11/27/2018 is 331, and not what qlik is saying, 331.  Even when hardcoding daynumberofyear('11/26/2018') it is showing 331.

https://www.epochconverter.com/daynumbers

1 Reply
Highlighted

Re: Day number of Year wrong?

Qlik assumed a year of 366 days

DayNumberofYear

 

=DayNumberOfYear(MakeDate(2018, 2,  28)) = 59
and 
=DayNumberOfYear(MakeDate(2018, 3,  1)) = 61