Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I resolved the situation by using an IF function, so I could put the condition OR / AND.
Try this
Count({<Date Created={"<= 01/01/2012"},Altered Date-={'*'}+Altered Date={">=01/01/2012"}>}Customers)
Thanks Sivaraj, for the response but don't work.
The QlikView, indicates that the expression has error.
More anyone have any idea?
Try this
Count({<[Date Created]={"<=01/01/2012"}, [Altered Date]-={'*'}*[Altered Date]={">=01/01/2012"}>}Customers)
Hope this helps
Thanks Manideep, but it did not work.
I resolved the situation by using an IF function, so I could put the condition OR / AND.