topic Number of Days in QlikView https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889643#M309972 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I m stuck off facing the issue to get days number field. here below the scenario is</P><P>There are 365 days in common and 366 days in leap year calendar. </P><P>In qlikview there's a function called <STRONG>Day</STRONG> which gives number of days in particular month. But i want </P><P>Number of days field&nbsp; up to today's date .</P><P><STRONG>like</STRONG> : if Jan month having 31 days then <STRONG>new field</STRONG> gives 1,2,3,4,5,6....upto 31 and if when Februrary month starts then in the same field&nbsp; it starts from 32,33,34,35,36....... and add on.</P><P>So, if i in case of previous year&nbsp; the <STRONG style="font-size: 13.3333330154419px;">new field </STRONG>should give the values from 1 to 365 days. </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hope you got it.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Any help will be appreciable.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Mohit </SPAN></P></BODY></HTML> Fri, 10 Apr 2015 04:07:08 GMT er_mohit 2015-04-10T04:07:08Z Number of Days https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889643#M309972 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I m stuck off facing the issue to get days number field. here below the scenario is</P><P>There are 365 days in common and 366 days in leap year calendar. </P><P>In qlikview there's a function called <STRONG>Day</STRONG> which gives number of days in particular month. But i want </P><P>Number of days field&nbsp; up to today's date .</P><P><STRONG>like</STRONG> : if Jan month having 31 days then <STRONG>new field</STRONG> gives 1,2,3,4,5,6....upto 31 and if when Februrary month starts then in the same field&nbsp; it starts from 32,33,34,35,36....... and add on.</P><P>So, if i in case of previous year&nbsp; the <STRONG style="font-size: 13.3333330154419px;">new field </STRONG>should give the values from 1 to 365 days. </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hope you got it.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Any help will be appreciable.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Mohit </SPAN></P></BODY></HTML> Fri, 10 Apr 2015 04:07:08 GMT https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889643#M309972 er_mohit 2015-04-10T04:07:08Z Re: Number of Days https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889644#M309973 <HTML><HEAD></HEAD><BODY><P>Hi Mohit,</P><P></P><P>Try using DayNumberOfYear function.</P><P></P><P>Muthu</P></BODY></HTML> Fri, 10 Apr 2015 04:26:05 GMT https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889644#M309973 Muthu 2015-04-10T04:26:05Z Re: Number of Days https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889645#M309974 <HTML><HEAD></HEAD><BODY><P>Use the function DayNumberOfYear()</P></BODY></HTML> Fri, 10 Apr 2015 05:07:17 GMT https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889645#M309974 PradeepReddy 2015-04-10T05:07:17Z Re: Number of Days https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889646#M309975 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Use&gt;&gt;&gt;&gt; DayNumberOfYear()</P><P></P><P></P><P>Regards,</P><P>Nagajuna</P></BODY></HTML> Fri, 10 Apr 2015 05:27:16 GMT https://community.qlik.com/t5/QlikView/Number-of-Days/m-p/889646#M309975 nagarjuna_kotha 2015-04-10T05:27:16Z