Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Qlik assumed a year of 366 days
=DayNumberOfYear(MakeDate(2018, 2, 28)) = 59 and =DayNumberOfYear(MakeDate(2018, 3, 1)) = 61