case when with aggregation

Saugandh — Sat, 16 Nov 2024 19:48:30 GMT

Hi,

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%

many thanks

saugandh

Re: case when with aggregation

JGMDataAnalysis — Sat, 26 Oct 2019 16:33:12 GMT

I don't know the content of the variables, but the dollar sign is not well positioned.

For example: ~~'($vWeek_S1)'~~ '$(vWeek_S1)'

topic case when with aggregation in App Development

case when with aggregation

Re: case when with aggregation