Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
q11hhg
Contributor III
Contributor III

distinct count of customers in the past 12 months

Hi there

I am struggling to figure out how to count the number of customers that purchased more than 3 times in the past 12 months. The result given by the expression below is empty.

COUNT({<
[Customer ID] = {"=sum({<

[Type]={'P'}Date={">=$(=date(addmonths(Max(Date),-12),'YYYY-MM-DD'))<=$(=date(Max(Date),'YYYY-MM-DD'))"}
 

[Total Events])>=3"}

                  >}distinct [Customer ID])

Please help 

Labels (2)
1 Reply