topic Re: multiple null condition in QlikView

multiple null condition

Anonymous — Sun, 12 Aug 2018 06:15:49 GMT

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

Re: multiple null condition

tamilarasu — Mon, 13 Aug 2018 17:23:50 GMT

Hi Bayan,

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

Re: multiple null condition

Anonymous — Mon, 13 Aug 2018 19:09:51 GMT

I am using Qliksense not Qlikview

Re: multiple null condition

tamilarasu — Tue, 14 Aug 2018 02:52:23 GMT

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

Re: multiple null condition

fabdulazeez — Tue, 14 Aug 2018 04:14:23 GMT

something like this

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