Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
balmoshiegah
New Contributor

multiple null condition

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

4 Replies
Highlighted

Re: multiple null condition

Hi Bayan,

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

Highlighted
balmoshiegah
New Contributor

Re: multiple null condition

I am using Qliksense not Qlikview

Highlighted

Re: multiple null condition

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

Highlighted
Partner
Partner

Re: multiple null condition

something like this

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