Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
er_mohit
Master II
Master II

Number of Days

Hi all,

I m stuck off facing the issue to get days number field. here below the scenario is

There are 365 days in common and 366 days in leap year calendar.

In qlikview there's a function called Day which gives number of days in particular month. But i want

Number of days field  up to today's date .

like : if Jan month having 31 days then new field gives 1,2,3,4,5,6....upto 31 and if when Februrary month starts then in the same field  it starts from 32,33,34,35,36....... and add on.

So, if i in case of previous year  the new field should give the values from 1 to 365 days.

Hope you got it.

Any help will be appreciable.

Regards

Mohit

1 Solution

Accepted Solutions
Muthu
Partner - Creator III
Partner - Creator III

Hi Mohit,

Try using DayNumberOfYear function.

Muthu

View solution in original post

3 Replies
Muthu
Partner - Creator III
Partner - Creator III

Hi Mohit,

Try using DayNumberOfYear function.

Muthu

PradeepReddy
Specialist II
Specialist II

Use the function DayNumberOfYear()

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi ,

Use>>>> DayNumberOfYear()

Regards,

Nagajuna