multiple null condition

[Anonymous]

how can i write multiple null condition in this kpi ?

Employees nearing retirement age

select  count(source_person_id) FROM DIM_PEOPLE where EMPLOYEE_NUMBER is not null and END_OF_SERVICE_DATE is null and original_date_of_hire is not null and DateDiff(year , DOB,getdate()) >58

[tamilarasu]

Hi Bayan,

You can use above SQL query directly in Qlikview. Are you getting any error?

[Anonymous]

I am using Qliksense not Qlikview

[tamilarasu]

Is this not working in QlikSense? Did you get any error?

[fabdulazeez]

something like this

Count({<EMpno=-{''},eos={''},dob={"<$(=AddYears(Today(),-58))"}>}EMpno)