
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get the customers that are not part of the sales in the last three months? using Year Month
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
It should be only this.
Count({<Customer = e({<Date = {">=$(=Addmonths(Max(Date),-2))"}>})>}Customer)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 )
