Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Calculating Day no. From Start of the year

use  DayNumberOfYear(YourDateField)

anant

View solution in original post

9 Replies
Highlighted
Specialist II
Specialist II

Re: Calculating Day no. From Start of the year

PFA

Hope it helps

Highlighted
Specialist
Specialist

Re: Calculating Day no. From Start of the year

use  DayNumberOfYear(YourDateField)

anant

View solution in original post

Highlighted
Specialist II
Specialist II

Re: Calculating Day no. From Start of the year

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

Highlighted
Creator III
Creator III

Re: Calculating Day no. From Start of the year

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

Highlighted
Not applicable

Re: Calculating Day no. From Start of the year

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

Highlighted
Partner
Partner

Re: Calculating Day no. From Start of the year

just use the function DayNumberOfYear(datecolumn).

Highlighted
Creator III
Creator III

Re: Calculating Day no. From Start of the year

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

Highlighted
Not applicable

Re: Calculating Day no. From Start of the year

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..

Highlighted
Specialist
Specialist

Re: Calculating Day no. From Start of the year

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