Identify Frequent Buyers

[qlikwiz123]

I have below columns in my table.

Purchaser ID

Purchaser Name

Sale ID

Sale Date

Sale Amount

How do I identify frequent buyers (Which Purchaser is buying frequently) in the current month, last 3 months, and overall with this available data?

[Patricia_Silva]

Hello @qlikwiz123 there are many way to know which purchaser has been the one that bought the maximum numbers of item in a certain period of time. I am not sure how you want to visualize it but I created a simple Qlik Sense application that might give you an idea. In this case I just used a bar chart (but it can be any visualization that you think is the best in your case) and just used count aggregation. Please let me know if that is what you are trying to achieve. 😊

[qlikwiz123]

@Patricia_Silva  Thank you so much. I am working on QlikView and don't have Sense. Can I have this in QVW format so that I can take a look? Appreciate it