Set Analysis (or condition)

[#1]

Hello,

Anyone have any idea how to implement this in Set Analysis:

Count(Customers)

Where -> Date Created <= 01/01/2012 and (Altered Date Is Null or Altered Date> = 01/01/2012)

Regards.

[sivarajs]

Try this

Count({<Date Created={"<= 01/01/2012"},Altered Date-={'*'}+Altered Date={">=01/01/2012"}>}Customers)

[#3]

Thanks Sivaraj, for the response but don't work.

The QlikView, indicates that the expression has error.

More anyone have any idea?

[manideep78]

Try this

Count({<[Date Created]={"<=01/01/2012"}, [Altered Date]-={'*'}*[Altered Date]={">=01/01/2012"}>}Customers)

Hope this helps

[#5]

Thanks Manideep, but it did not work.

[#6 · Accepted solution]

I resolved the situation by using an IF function, so I could put the condition OR / AND.