Dynamic Date Range Calculation

[#1]

Hi,

Is there any function in Qlikview for Creating a date field in the backend which comprises of the range - 1 to 365 Days for a particular year.

Note: It should be dynamic as per the Year selection since I want to create a dynamic bucket considering these Days.

e.g: 1.1.2010 should be equal to 1 and 12.12.2010 should be equal to 365.

Thanks in advance.

Regards,

Mandar

[maneshkhottcpl · Accepted solution]

Hi Mandar, I have one solution to resolve ur problem. use the script

num

(Date1+1)-num(makedate(year(Date1),1,1)) as DayNumber

also refer the Attached Application

[#3]

Thanks Manesh

Cheers,

Mandar