Set Analysis Expression with date range & null

[#1]

Hello,

What's wrong with my expression?

Count({<[Dealer Hire Date] = {'<=12/31/2015'},[Dealer Term Date] = {"$(= '>=' & '01/01/2015' & '<=' & '12/31/2015')" or null}>}[Student ID])

I am trying to count Student ID where their Dealer Hire Date is Less Than or Equal to 12/31/2015 AND they either have a Dealer Term Date in-between the dates of 01/01/2015 - 12/31/2015 OR they don't have a Dealer Term Date.

My KPI object keeps returning the value of 0. I have a feeling my problem fall within how I am writing in the expression 'OR NULL'.

Suggestions on how to write this?

[miguelbraga]

Try this:

Count({<
[Dealer Hire Date] = {'<=12/31/2015'},
[Dealer Term Date] =
     p(
          1{
          [Dealer Hire Date] = {'<=12/31/2015'},[Dealer Term Date] = {"$(= '>=' & '01/01/2015' & '<=' & '12/31/2015')")}

            } [Dealer Hire Date]

)
>}

[Student ID])

Hope it helps

Regards,

MB

PS: this function was made using the help of the document provided by this post:

Set Analysis: syntaxes, examples

[#3]

That didn't work. It returned a "-" in my KPI. Thanks for trying.

[miguelbraga]

What is the range of dates you're trying to achieve in Dealer Hire Date?

I also think that the problem is the use of "or null" in Set Analysis expression. Let me search a bit more

[miguelbraga]

Have you tried simply with this expression?

Count({<[Dealer Hire Date] = {'<=12/31/2015'},[Dealer Term Date] = {"1(= '>=' & '01/01/2015' & '<=' & '12/31/2015')"}>}[Student ID])

[#6]

This gives me the value of 0.

[#7]

I want the count of students who were hired before 12/31/2015.

And who are currently still employed (null for Dealer Term Date) or have a Dealer Term Date between 01/01/2015 and 12/31/2015.

I'm trying to get the beginning population for the year of 2015.

[miguelbraga]

Give this a try:

Count({<
[Dealer Hire Date] = {'<=12/31/2015'},

[Dealer Term Date] = {"$(= '>=' & '01/01/2015' & '<=' & '12/31/2015')")} + {''}
>}

[Student ID])

Regards,

MB

[#9]

Returns a "-"

[miguelbraga]

Maybe this:

Count({<
[Dealer Hire Date] = {'<=12/31/2015'},

[Dealer Term Date] = {"$(= '>=' & '01/01/2015' & '<=' & '12/31/2015')")},

[Dealer Term Date] = {"$(=null())"}
>}

[Student ID])

Regards,

MB