topic Identify Frequent Buyers in QlikView

Identify Frequent Buyers

qlikwiz123 — Thu, 25 Mar 2021 13:55:44 GMT

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?

Re: Identify Frequent Buyers

Patricia_Silva — Thu, 25 Mar 2021 14:51:24 GMT

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. 😊

Re: Identify Frequent Buyers

qlikwiz123 — Thu, 25 Mar 2021 15:42:31 GMT

@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