Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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