Show all customers who have not ordered anything the past 6 months

[Hansa1]

Hi, I'm very new to Qlik so please bear with me 🙏

I have an expression that returns all customers who have ordered the past 6 months: 

=count({<OrderDate = {">=$(=Date(AddMonths(Max(OrderDate), -6)))<=$(=Date(Max(OrderDate)))"}>} DISTINCT CustomerID)

But my goal is to return all customers who have not ordered anything the past 6 months. How can I do this? 

Thanks!

[Gabbar · Accepted solution]

Exclude these Customers using exclude like:-

count({<

CustomerID=e({<OrderDate = {">=$(=Date(AddMonths(Max(OrderDate), -6)))<=$(=Date(Max(OrderDate)))"}>})

>} DISTINCT CustomerID)

Remeber now there are two set expression here , one of exclude and one complete, so please make sure which filters affect which expressions.

[Hansa1]

Thanks for the help Gabbar!