Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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. 😊
@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