i was wondering if someone would be able to help me . I want to create the following Case statement in Qliksense.
emp_id ,
"case when a.START_DT BETWEEN '08NOV2019'D AND '15NOV2019'D and a.apo_ID <> '' then 1 else 0 end as nov_08_15chk_appointments,"
basically there is no record for appointment(no Apo_id) for some employee on some particular date that i can find through above query in sas and then i have to aggregate the employee level info on region wise, i tried the below script but i am not getting the correct output.
if (START_DT >= '($vWeek_S1)' and START_DT <= '($vchk2)' and ACTV_ID <>'', 1,0) as week1%, // if (START_DT >= '($vWeek_S2)' and START_DT <= '($vchk3)' and ACTV_ID <>'', 1,0 ) as week2%
