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

## Re: Calculating Day no. From Start of the year

use  DayNumberOfYear(YourDateField)

anant

9 Replies
Highlighted
Specialist II

PFA

Hope it helps

Highlighted
Specialist

## Re: Calculating Day no. From Start of the year

use  DayNumberOfYear(YourDateField)

anant

Highlighted
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

## Re: Calculating Day no. From Start of the year

Hello,

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

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

## Re: Calculating Day no. From Start of the year

just use the function DayNumberOfYear(datecolumn).

Highlighted
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

## Re: Calculating Day no. From Start of the year

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