How to get the customers that are not part of the sales in the last three months? using Year Month

[Qlikuser09]

Customer ID	Purchase year month
1	2021-4
2	2018-3
2	2021-2
3	2021-1
4	2018-4
4	2020-4
5	2021-5
6	2021-6
7	2021-7
7	2018-5
8	2017-3
9	2020-7
10	2020-3
11	2021-1

({$<Customer ID=p()*e({<Date={">=$(=AddMonths(Max(Date),-3))<$(=Max(Date))"}, YearMonth=>}), YearMonth=>} This is not working

[kaushiknsolanki]

Hi,

It should be only this.

Count({<Customer = e({<Date = {">=$(=Addmonths(Max(Date),-2))"}>})>}Customer)

[Qlikuser09]

=Count({<[Customer ID]=E({<Date={">=$(=addmonths(max(Date),-2))<=$(=max(Date))"}>}[Customer ID])>}Distinct [Customer ID )

This gives me customers  that are not been active for the past two months , but however I need the customers that are not active /not part of the sales product (not active for each specific product in the last two months)

[Kushal_Chawda]

@Qlikuser09  create a graph or table with below dimension and measure will give you what you want

Dimension: Product

Measure: 

 Count({<[Customer ID]=E({<Date={">=$(=addmonths(max(Date),-2))<=$(=max(Date))"}>}[Customer ID])>}Distinct [Customer ID )