Number of customers who have purchase several time during a period
I've the customer transaction data set in the attachment. based on which I want to create a table in order to show, the number of customers who have purchased "More than one time within a month" & "More than one time in both current months & last month or last two months"?
I'm expecting something like this (the following result is calculated based on the attached dataset):
I have also attached a workshop I wrote about Set Analysis. The workshop is written for Qlik Sense but don't let that throw you at all. Set Analysis works exactly the same in QlikView. While you can't do the hands on aspect of it, you can at least read and get some examples. You will see that it starts out very simply and builds up to the kind of level you need to handle what you are looking for.