topic Dynamic Date Range Calculation in QlikView

Dynamic Date Range Calculation

Fri, 10 Dec 2010 07:55:26 GMT

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 — Fri, 10 Dec 2010 08:16:55 GMT

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

Fri, 10 Dec 2010 08:23:45 GMT

Thanks Manesh

Cheers,

Mandar