start date to end date apply the condition

nvijay5757 — Sat, 16 Nov 2024 16:52:56 GMT

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.

topic start date to end date apply the condition in App Development

start date to end date apply the condition