start date to end date apply the condition

[nvijay5757]

Hi,

i have the data start_date, end_date.  kick_date, estimated_date

my requirement is : from start to end to display every weekstart and mark with color code.

if kick_off=y then blue, if kick_off=n then grey

kick date-> blue color starting

estimated date -> grey color starting

end date -> green color mark.

i have done from start to end date weekstart i.e fine     nd marked with blue color also like 'y' and 'n'.

Input_Data:
LOAD 
Date(Date#(startdate,'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD') as start_date,

date(Date#(enddate,'YYYY-MM-DD'),'YYYY-MM-DD') as end_date


DateOrderLink:
LOAD 
Date(start_date+ IterNo() - 1) as start_date
RESIDENT Input_Data
While Date(start_date + IterNo() - 1) <= end_date
;

and color code :

=if(Kick_Off ='Y',LightBlue(),
if(Kick_Off ='N',LightGray(),
))

i need help regarding, can anyone help me please. to apply the below conditions(i am using pivot table - qlikview)

kick date-> blue color starting

estimated date -> grey color starting

end date -> green color mark.

if kick date is not available then consider estimated date.