topic Re: Set Analysis (or condition) in QlikView

Set Analysis (or condition)

Tue, 05 Mar 2013 00:20:55 GMT

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 — Tue, 05 Mar 2013 04:48:49 GMT

Try this

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

Tue, 05 Mar 2013 10:01:12 GMT

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

The QlikView, indicates that the expression has error.

More anyone have any idea?

manideep78 — Tue, 05 Mar 2013 11:25:29 GMT

Try this

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

Hope this helps

Thu, 07 Mar 2013 10:57:21 GMT

Thanks Manideep, but it did not work.

Thu, 07 Mar 2013 11:19:51 GMT

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