Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Day no. From Start of the year

hi all,

i want to know what is day number of specific day from start of the Year

like

for feb 1 is 32nd day of the year

Dateday no
feb 132
feb 233
feb 334
feb 435
feb 536
feb 637

like this ..

thanks

1 Solution

Accepted Solutions
anantmaxx
Specialist
Specialist

use  DayNumberOfYear(YourDateField)

anant

View solution in original post

9 Replies
gupta_n8
Specialist II
Specialist II

PFA

Hope it helps

anantmaxx
Specialist
Specialist

use  DayNumberOfYear(YourDateField)

anant

View solution in original post

gupta_n8
Specialist II
Specialist II

Moreover if you dont want to deal with rowno(),

create a chart,

take TempDate as dimension and expression as follows:

=(max(TempDate)-YearStart(max(TempDate)))+1.

It will also work

sureshbaabu
Creator III
Creator III

Hello,

Create a variable to define the start of the year (vYearbeginddate=1/1/2014)

in your expression use  'datecolumn-vYearbeginddate'

hope this helps

thanks

Not applicable
Author

Hi ,

Use this function   DayNumberOfYear(Date) ..

Then U will Get day No for Particular date .. Easily..

If U Want day no According to fiscal year then U need to provide Off set To the Function Like this

-->  DayNumberOfYear(Date , 4)  or DayNumberOfYear(Date , starting month of Year)

Hope It Helps

Regards,

koti reddy

edwinmatlapeng
Partner
Partner

just use the function DayNumberOfYear(datecolumn).

sureshbaabu
Creator III
Creator III

Note:

The results after using DayNumberOfYear(Date) for the current year(2014) is perfect.

but make sure incase if you use this function for date values for multiple year.. because it returns 3 for both 01/03/2014 , 01/03/2013

Thanks

Not applicable
Author

Yeah Suresh ,

It Will return like That Only ..

If U want it to according to Ur database dates .. Create a master Calendar and  U can put Rowno() as Dayno .

Then It Will count days from beginning Year ..  If U want..

Shubham_Deshmukh
Specialist
Specialist

what if we need it it in reverse ?
001 - 01JAN